title: Extracting information using a cell reference in a file reference
body: <p>I am using Microsoft Excel to draw data from multiple files on a server, however to get this data they are located on different sub files which is determined by a cell on my excel spreadsheet.</p>
  <p>For example I have in my formula:</p>
  <pre><code>='http://website.com/Subfolder/C9/[Contents.xlsm]Contents'!$Y$123
  </code></pre>
  <p>I cant get the formula to recognise the cell reference in this case <strong>C9</strong>. This is located within the active sheet. If I replace this with the file name manually this works fine.</p>
  <p>I have tried using Concatenate and using a macro but couldn't get it working.</p>
  <p>Many thanks</p>