Get 1 table pulling from several worksheets

[pendulum]

I'm looking for a good approach here with this data and how to parse it.

I have a webpage which gives 1 messy table of raw data for each month; each a separate page.
I've been doing select-all -> paste into excel, and from that I parse into a nice a table on a new worksheet.

But now another month comes in, and because it's tricky to paste onto the previous raw data worksheet, I make a new one worksheet.

Now how do I get all this stuff to seamlessly come together?
Just manually change the formula to pull from a new worksheet each month? Then excel doesn't like that inconsistent formula.

What's a good approach here?

 

[GraH]

You can look for a good tutorial on how to combine data from multiple sheets through Power Query (Get & Transform).
Or maybe even get it connected to that website directly.