title: Use text from cell with IMPORTRANGE
body: <p>I have two Google Sheets: the first contains data per week and the second gives an overview of that data. The sheets in the first are named by week. For example: <code>Week 1</code>, <code>Week 2</code>, <code>Week 3</code>, <code>Week 4</code> ... The sheets in the second contain one cell which has the same text as the sheet names of the first document. This cell is A1.</p>
  
  <p>Using the IMPORTRANGE function I want to show some data from the first (data) document in the second (overview) document. Currently the IMPORTRANGE formula looks like this:</p>
  
  <pre><code>=IMPORTRANGE("https://docs.google.com/...; "Week 1!C2:C5")
  </code></pre>
  
  <p>As you can see I have to change the sheet name I reference to manually. I want it to change automatically using the text in cell A1. So it should look like this:</p>
  
  <pre><code>=IMPORTRANGE("https://docs.google.com/...; "A1!C2:C5")
  </code></pre>
  
  <p>Is it possible to do it like this or do I need a script and how can I make it work?</p>