Dynamic list of worksheets based on tab colour

[JasonBing]

I have a workbook with about 16 admin and finance sheets. Then the rest of sheets contain the data for each job, like job cards. These sheets are coloured blue and the admin sheets are coloured green. I have been asked to create another admin sheet with a dynamic list of sheet names with hyperlinks. But they only want the blue sheets to be shown on this list, so they can easily navigate to the job cards to update them.

I am stumped.

Any help would be greatly appreciated.

Thanks

Jason Bing

 

[JasonBing]

Awesome mate you are a legend. Now it works with the guys fat fingers.

Have a great day

Thank you

Jason Bing

 

[JoeMo]

Awesome mate you are a legend. Now it works with the guys fat fingers.

Have a great day

Thank you

Jason Bing

You are welcome - thanks for the reply.