Changing a Pivot Table total range

[Yusuf]

Hi all

Is it possible to change my total pivot table range.
The maximum rows I get to use in my Pivot is 18000 and have to create tables below each other but the worst is finding the previous range and inserting another headings row for the new pivot.

Any suggestions would be appreciated