title: Reference a worksheet from its name in a cell using VBA
body: <p>I am trying to find out how to make a reference that is defined by a cell value using VBA.</p>
  
  <p>I have a form that inputs the name and location of a workbook into a cell (eg A1).  I then want my VBA code to take the value of this cell as a reference to the location of that file.</p>
  
  <p>Instead of the reference being "f:test/file.xls" I would like it to be 'f:test/filedata.xls sheet1 A1' (clearly not a filepath but hopefully you get the idea).</p>
  
  <p>This will allow me to build a set of interconnected workbooks that can be stored in different places and have different names without hard coding the locations every time (userform to input locations into the cells is used).</p>
  
  <p>i am not sure if this is possible, and I certainly can't see anything like it yet.  Here's hoping!</p>
  
  <p>Cheers</p>