VBA/Power Query To Extract Cells With A Background Cell

[Stacker]

Hi I have a folder with many excel files, I want to filter out all the cells with a background colour which are often the headings of table. From there, I want to copy and paste the heading(cell contents) into a new file. How do i use VBA/Power Query when the tables across the different workbooks are different sizes.

 

[abuahad]

I also need this solution, can anybody please help us?

 

[Stacker]

Anyone? All of the cells in headings were white if that helps.