Refer to correct sheet via other cell in formula

[ferodo]

Hi all,

I' like to automatically refer to the correct data sheet with the name of the sheet in another cell.


So,
=GETPIVOTDATA("SALES";'PIVOT 2015'!$A$3;"COUNTRY";"BELGIUM")
becomes something like
=GETPIVOTDATA("SALES";B5;"COUNTRY";"BELGIUM")
where cell B5 contains the text: 'PIVOT 2015'!$A$3

It does not work now, I suppose the content of cell B5 is not correct at the moment.

Is this possible?
I want to do this because othwerwise I'll have to link the pivot again for every column(every column needs data from another pivot table, which are in a different sheets)

I hope this is possible
Thanks a lot!

[TPDave]

Can you post a sample workbook?

[AliGW]

Like this:

=GETPIVOTDATA("SALES";INDIRECT("'"&B5&"'!$A$3");"COUNTRY";"BELGIUM")
where cell B5 contains the text: 'PIVOT 2015'!$A$3