Excel indexing

[jon]

Hi,

I have an excel sheet containing a simple structure. For
example.

col1 col2 col3 col4 col5
-------------------------------------
cat dog mouse rat bear
dog cat sheep bear squiral
... .. .. .. ..


Then i want to create a index worksheet that updates
automatically when the sheet containing the data above is
ammended.

The index has to sort out priorities. so for example the
word cat appears in col 1 of row 1 so would be listed
first in the index (all the other animals in the same row
would be displayed, i.e the whole row duplicated). Then if
cat appears in another row (depending on its column
location) it would be ranked differntly in the index.

Then i want to use the same index page to add in other
animal priorities. The index i'm hoping to produce should
look like this:

Index name col1 col2 col3 col4 col5
----------------------------------------------------
cat cat dog mouse rat bear
cat dog cat sheep bear squiral
cat dog mouse cat rat bear
cat dog squiral sheep bear cat
dog dog cat sheep bear squiral
dog dog mouse cat rat bear
dog dog squiral sheep bear cat
sheep dog cat sheep bear squiral
sheep dog squiral sheep bear cat
sheep dog mouse cat rat bear


Any help would be appreciated

Thanks

Jon