Pivot table with dynamic sheet (!) reference

[pi]

There is a well know solution to use dynamic ranges as source of a pivot table (name using offset). In my case I want to take it one step further. I want to put the name of a sheet into a cell and derive the source of the pivot table from that.

Here is what I tried:

1: I have defined a name CurrentIC: =OFFSET(INDIRECT(ADDRESS(1;1;1;;Eval!$A$2));0;0;Eval!$C$2;Eval!$B$2)
Here Eval!$A$2 hast the sheet name, Eval!$C$2 the calculated height and Eval!$B$2 the calculated width of the table
This name actually works. If I enter it the correct table is displayed
2: I want to create a pivot table using CurrentIC as the source. Yet I get the message "Data source reference is not valid."

What do I do wrong? Any alternative approach to get to the desired result?

pi

 

[pi]

Really nobody? Is that request so absurd?

 

[RoryA]

It seems to just be too much indirection. This works for me:

=OFFSET(INDIRECT("'"&Eval!$A$2&"'!A1");0;0;Eval!$C$2;Eval!$B$2)

 

[pi]

Hooray! Thank you!