title: How to use a cell as a filename in a reference in excel?
body: <p>If I have a cell, "<code>a2</code>" which has part of a filename/filepath, "<code>sheet2.xlsx</code>" in it which I want to use as a reference another workbook, how can I accomplish this?</p>
  
  <p>I have tried using the <code>INDIRECT</code> function but always get a reference error.</p>
  
  <p>I am trying to find a way to summarize a list of spreadsheets with column <code>a</code> containing the spreadsheet name and another column referencing a cell inside that respective sheet.</p>