I hate having to post things here that I feel like I should be able to google - but I swear I have wasted half a day trying to figure this out.
I'm trying to do 2 things - run my formatting macro on all worksheets that have "Budget Comparison" in A2.
Secondly, create a summary sheet that gives me Row 1 of all worksheets with BC in A2 and any lines that have been highlighted on those worksheets through conditional formatting. If I need to add a column that shows which rows that includes, I'm ok with that too. (A summary sheet for managers of all variances that need to be explained in up to 20 sheets so they are all summarized in one place).

I've created a sample worksheet with a Summary page which is what I would like it to look like as well as 2 tabs that should pull into the Summary and one that should not.
Example Workbook.xlsx
Thank you so much to anyone that can help me! I promise I'm learning from these and not just copying and pasting!