title: Refer to PivotTable name in cell in GetPivotData
body: <p>I've to a formula like the one below.</p>
  
  <pre><code>=GetPivotData("number";'Sheet2'!$A$3)
  </code></pre>
  
  <p>Now, I want to make the second value, the 'PivotTable' value, variable. I have the variable value in a cell, so I tried something like the following</p>
  
  <pre><code>=GetPivotData("number";A1)
  </code></pre>
  
  <p>Cell A1 contains the following:</p>
  
  <pre><code>'Sheet2'!$A$3
  </code></pre>
  
  <p>For some reason, this doesn't work. I have no clue how to solve this and I can't seem to find it anywhere else.</p>