Is it possible to check the colour of a worksheet tab through code? if yes
how?

I have red tabs and green tabs and want to create a summary sheet of only
the red sheets

Thanks