Numbers update as per Pivot table

[Veeru]

Hi,

Looking for a help excel frmula.which update my numbers in Final sheet as per date selected in Pivot Table

Example file attached, Where our numbers are changing in Final sheet for 2018-Actuals

As we select 2016-Actuals or any other date , numbers should be updated in final sheet as well.

Any help really appreciated.

Thanks

[p45cal]

perhaps something along the lines of:
=GETPIVOTDATA(TEXT($A3,),Pivot!$A$3,"Month",Pivot!$A$5,"Name","ABC")

[Veeru]

That's great..thank you very much