Get the VBA code here https://www.bluepecantraining.com/hide-excel-sheet-based-on-sheet-tab-colour-vba-macro/

This video details the Excel VBA code needed to hide worksheets based on their sheet tab colour. The first example details the code to hide sheets with a sheet tab formatted with any colour. The second, demonstrates how to specify a particular colour.
------------------------