Finding the position/range of pivot tables

To all experts of MS Excel & VBA Excel,

I've been trying to write a code that could help me find the position/range/cell of the pivot table.

A little explanation, I make multiple pivot tables in a worksheet called "Pivot". These pivot tables are found on cell A5 (1st pivot), A36 (2nd pivot), A67 (3rd pivot) and A98 (4th pivot).

I know how to write the codes that shows me how many pivot tables are there in "Pivot" worksheets, but I couldn't be able to write in which position/range/cell are these pivot tables at.

The reason why I wanted to do this is that, I want to make the pivot tables in order, i.e. 3 rows after the pivot 1, is a new pivot, which is pivot 2, and so on. Also, with this in mind, I could refresh which pivot tables I want instead of doing a refresh all, which is what i have the code doing right now.

Thank you in advanced to those who're helping me out.