title: Use string value from a cell to access worksheet of same name
body: <p>I have 2 worksheets: <code>Summary</code> and <code>SERVER-ONE</code>.</p>
  
  <p>In cell <code>A5</code> on the Summary worksheet, I have added the value <code>SERVER-ONE</code>.</p>
  
  <p>Next to it, in cell <code>B5</code>, I would like a formula that uses the value in <code>A5</code> to display the value of <code>G7</code> in the worksheet of the same name (<code>SERVER-ONE</code>).</p>
  
  <p>I could manually use:</p>
  
  <pre><code>='SERVER-ONE'!G7
  </code></pre>
  
  <p>However I would like this to be dynamic, so I can easily add more worksheets.</p>
  
  <p>I tried the obvious with no joy:</p>
  
  <pre><code>='A5'!G7
  </code></pre>
  
  <p>Any suggestions?</p>