Hide Rows in Index Sheet Based On Color Of Other Tabs

First of all, thank you all, I have been using this forum for a while now and have really sharpened my Excel skills. But I could not find an answer to my current problem.

I have a workbook with about 350 Worksheets (I know its a lot, but it's needed). This workbook is a template of many different projects, some sheets are needed for some projects, some aren't

In this workbook, I have a index sheet that lists each sheet name and a description (reference from a cell on each sheet). Each Description is a hyperlink to that particular sheet. (This index sheet is done with formulas rather that a macro, when I tried a macro that I found, it was WAY to slow)

For each project, I change the color of the tabs to green for the sheets I will need.

I would like to have another "index" sheet that just shows a list (preferrably with hypler links) of the sheets with green tabs.

If you need me to attach the file I will but I will have to wait untill I get home from work (no way to zip it)


Any help would be greatly appreciated.

Happy Holidays

Mark