Growing Pivot Table - Outside Cell References Constant Manual Adjustment

Hi,

I have a pivot table that grows each month and with this pivot table I have a bunch of cell links/cell references. These references require readjustment every month as the pivot table grows. I was wondering if there is a better way to go about creating this? Is there a way to dynamically refer to the same cells with the new dates?

In the attached example file, I have provided a snapshot of what I do for one month. So, for Sept 2019 and Sept 2020 comparison - this would be fine, my cell refences work great.

However, when I am to update and compare just October 2019 and October 2020, all my cell references would be thrown off (because I have a new data, expanding the pivot table horizontally).

When I load in November data, my October references will be thrown off etc etc.

How would I go about modifying and improving upon this?

Thanks for all your help!

Thanks Jete, that makes sense!

I'm not sure if you can help further.

If I was to flip the axis, and have dates on Columns and Categories/Company/SubPortfolio on rows - how do I create a formula using your GetPivotData that I can simply drag down (Columns I29:I31) and which accommodates new information found in the pivot table?

In this case, in October, there was a new Subportfolio for an existing Publisher. Also, in October, there's a new Publisher entirely that wasn't present on earlier archives.

Specifically, the yellow highlights in the Attached 'Question 2' sheet.

Thanks!!