title: Building cell reference to another file from cell values
body: <p>I'm not sure if this is even possible. I need to make references to cells in multiple other Excel files.</p>
  
  <p>To make it simple: I can get the data I require with the following string, in Sheet1 of my workbook:</p>
  
  <pre><code>=SUM('C:\Folder\[Person''s Tracker.xls]April 2014'!$A$1:$A$54)"
  </code></pre>
  
  <p>It's referencing another workbook to <code>SUM</code> tracking data.</p>
  
  <p>However, I want to dynamically build this string using cell references from another sheet:</p>
  
  <ul>
  <li>"C:\Folder\" is stored as text in Sheet2, cell C5.</li>
  <li>"[Person''s Tracker.xls]" is stored as text in Sheet 2, cell D5.</li>
  <li>"April 2014" is stored as text in Sheet 2, cell E5.</li>
  </ul>
  
  <p>I've tried various combinations of <code>CONCATENATE</code> and <code>INDIRECT</code> but always end up with an error. Any ideas?</p>