Making a GETPIVOTDATA formula dynamic (different spreadsheets used)

[VoodooChild]

Hello,

I got the following code by recording a macro which fills a cell in a table, using a cell located in another worksheet, within a pivot table.

"=GETPIVOTDATA(""No of Tickets"",'[First Level Resolution.csv]IPVPN 1st Level'!R12C3)"

I need to convert the R12C3 to a dynamic cell and have located that cell dynamically and set it as x.

Any ideas as to how I can change the formula to use x instead of R12C3? Have tried different options with no luck.

Any help is appreciated. Thanks.