Identify values from same column on multiple sheets

[frankpat]

I have a workbook with multiple sheets (a new sheet is created every day). Column A of each sheet has product codes that are highlighted red yellow green or no formatting. I'm trying to create a worksheet that will show me the counts of each unique code. Can anyone help?
Thank you!

 

[dave2018]

What do you consider "unique" codes, is it dependent on their colors? Can you give an example of how you want the output worksheet should look like?

 

[frankpat]

Example of desired output