I currently have 2 pivot tables on 1 sheet directly above each other, with
all the total hidden so that it looks continuos. The reason I am using 2
pivot tables is as the data comes from different sheets.

The problem I have got is when I refresh the top pivot table as the contents
of the sheet it is pulling from is populated with more data it says that 'A
Pivot Table report cannont overlap another PivotTable report'

Is there anyway that I can prevent this from happening?

Can you set the format like on a chart where the pivot table will move if
more cells are inserted.

I hope that I have explained this well enough!

The Rook