title: Change an excel path to include a cell value
body: <p>I have a workbook that contains 50,960 paths to other workbooks</p>
  
  <p>I would like to be able to change part of the paths name to the value of a cell in my workbook (the value being a date)</p>
  
  <p>Example:</p>
  
  <p>='Z:\Folder\Data[Workbook 1.xlsm]10-01-18'!V5*</p>
  
  <p>I want to change the part of the path containing this date <strong>10-01-18</strong> to the value of cell <strong>B2</strong> instead (B2 already contains this date in my workbook).</p>