Power Query: Consolidating data from different worksheets

See attached mock-up containing 2 worksheets. My actual workbook extends to 30 worksheets and a new sheet is added each month. With the current layout it is hard for me to build reports (I don't own the workbook btw - it is sent to me by Accounts).

How do I consolidate data from different worksheets (30+) that contain the same data structure? The range I need to consolidate is C14:K37 (every other row is blank and I don't need it) and I also need data from cells F7, G9, J6, J9, J11 and E42, E44, E46,K42 and K44.

I looked at Power Query (PQ) but it seems I have to append data by creating tables (is this right?) - can PQ automate a routine to consolidate every worksheet in the workbook

Thanks for looking