Move Pivot Table to align with last row of other column

[Lochlan 1997]

I'm pretty new to using VBA, so please excuse my lack of knowledge or choice of words to describe my question

Alright so I have a;

-Pivot table 1 @ (A25:B29)

-Pivot table 2 @ (A31:B34)

-A regular table @ (D1:K50) ~ this table is constantly changing it's height (row count) could be K50 upto K60 sometimes

Hopefully the above details are clear

Okay so I would like to move the two pivot tables so that the bottom row of the lower table aligns with the regular table.

The desired end result would be (IF THE REGULAR TABLE'S BOTTOM ROW IS 50)

-Pivot table 1 @ (A41:B45)

-Pivot table 2 @ (A47:B50)

So I would like to know if there's a vba code to allow this to be done, as the regular table will be constantly updating and changing in height.