Pivot table overwrites neighbouring cells

[Anissa]

Hello,

I have multiple pivot tables on the same sheet to allow for easy comparison
of data. The source data is a web query that is based on weekly data. As the
week progresses, the size of the pivot tables will increase and overwrite
data below it.

I am looking for a workaround or if there is a way to set the pivot table to
insert a new row below it if the table size will increase.

Thanks in advance!

Anissa