title: Insert filename into directory link from cell value
body: <p>I've got a list of 150 filenames in column A e.g. WorkBook1-WorkBook150 and want to reference this when including the file directory so I will be able to reference a cell out of the workbook. The cell is an outstanding amount for a particular supplier so I wish to create a workbook to have a full overview of the outstanding amount and broken down for each supplier in a list.</p>
  
  <p>A1 filename: File1.xls</p>
  
  <p>So if filename 1 is in A1, is there a way to action this so we can pull the filename from A1 and insert it in the relevant place in the directory? It works if I input the text from A1 manually but referencing the cell into the relevant place would save a lot of time.</p>
  
  <p>Example of what I wish to input in B1: ='C:\Directory\FolderName[A1]Sheet1'!$D$4</p>
  
  <p>Thank you for your time!</p>