Link of Pivot data to other cells for automated data updation when pivot is refreshed

[shashi.excelcrazy]

Hi,

I need to update my table using pivot table(Which is at bottom of sheet) data and then multiply that data with given data in column E G & H. (Data attached)

It can be done by getpivotdata easlily and multiply that data with other columns percentages but i need to make this dynamic. Whenever i pull any information from pivot this function should work in column I J & K irrespective of whichever column i replace.

Any better and good technique of doing this? (except getpivotdata which is very manual)

Pls highlight steps of doing that.

Thanks