Hello everyone, again.

I am now trying to work out how if I can re-organise a long list of worksheets in a particular workbook based on something like the colour of that worksheet's tab or the data in a particular cell. I've seen how it can be done alphabetically using the following code:

Please Login or Register  to view this content.
So basically what I would like is that say for example in Cell C4 I have the word Rabbit or Hamster. I would like all the worksheets which have the word Rabbit to come first and all those containing Hamster to come second.

Or say for example half of the worksheet's tab are coloured orange and the other half are coloured blue how would I organise based on this.

Many thanks as always, you guys rock!

Tom