GETPIVOTDATA or Formula to get the Data from Pivot Table

Hi All,
I've explained everything in Index+Match tab as I suppose it would be easier.

So, briefly:

How or which formula to use to get the Data from Pivot table based on Month, but when I change the Date (Month) in cell C1 I would like to get new data automatically, not to change anything manually.

Thank you in advance.

I think I understand what you are looking for.

Incorporate this into each of your formulas that are needing the applicable date.

Please Login or Register  to view this content.

Change your :

Please Login or Register  to view this content.

into:

Please Login or Register  to view this content.

O man.....works perfectly!
Thank you very much!

You are very welcome.
Glad I could be of some assistance.