Merge multiple tables

Power Query with From Folder then add Month Name to each month next Append Queries (not merge) then you can filter or use Pivot Table

Wow, that was quick and almost too easy Thank you already very much!

Even though I was trying to follow each of your steps, I think I achieved my goal already after steps 1 and 2.

What I did was:
Get Data/from file/from folder and then Combine &, Load - and there it was!

But there are two issues:
1. Each CSV File has four lines of general header and one sum row footer. Can I get rid of those using this batch method? I did not see a moment to intervene when using this method.
2. Each CSV File has in row five table headers. I only want those once in the combined file. Any way to do this using the above method?

Last, apologies for not following your description 1:1, but can you elaborate on what you mean by "add Month Name to each month next Append Queries (not merge)"? Not sure where I would be able to execute that.

Thanks again!