Filter in new data to pivottable sheet - help!

[Jyggalag]

Hi all,

I currently have a sheet that looks like this:

(Please note that I have divided my excel file into two windows, so you can see both sheets at the same time).

I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my master data sheet (Sheet1) every week containing data in a similar manner, but with new numbers.

I would like to know, if I do this and I integrate the upcoming sheets (which will be named Sheet1 (2), Sheet1 (3) and so on unless I decide to manually rename them), is there any kind of formula/VBA code/macro that I can use, so the data automatically gets thrown into my pivot table?

I would truly appreciate some assistance here! Whichever solution can make this run as automatically as possible would be amazing

Thank you very much everybody!!

Kind regards,
Jyggalag