Appending 60 excel sheets & cleaning (Power Query)

[samparker095]

I need to append about 60 sheets into one table. the sheets come from a file with several sheets the sheets name is 'Contract Costs'. Each sheet has 9 header rows 9 that need to be deleted (although I'm not certain its going to be 9 rows every time, so a solution that had variable amount of junk rows would be useful).

I know how to append by extracting from a folder using Power Query, however I'm not sure how to do this basic cleansing across all sheets.

There is also a section of 6 columns (under fee/in blue) than can be deleted if easy.

I've attached Demo 1 & Demo 2 that show the data will be set out and Demo 3 the final outcome.