I am new with Pivot tables.

I am creating a weekly report which will have new data every week. This data is then plotted using pivot table and used in my report.

Every week the amount of rows in the raw data may change. I go to the raw data sheet, delete the current data and add the new raw data on it.

For example,
Jan 1st week has 109 rows
Jan 2nd week has 120 rows
Jan 3rd week has 90 rows
...
Dec 51st week has 112 rows

I am looking for a way for the pivot table to automatically change the data source to adjust to these rows. Since it does not happen automatically, I have to go to each table and change its data source manually. There are over 8 different raw data reports each month which I change. Just wondering if it is possible to automate it without using a macro.