Address of Pivot tables

[MyFathersBusiness]

I need to find the address of the last pivot table created on a sheet so i can add another one - basically i can do this by moving down the sheet but i want to control the process so it automatically looks for a suitable column once the rows reach say 100 to avoid scrroll down