title: Can I link to workbooks that haven't been created yet if I know what they will be named?
body: <p>We use an excel sheet (called an "Assign") to store info for a particular day. A new Assign is created each day and placed in the same folder, the previous day's is removed. I know what the name of the new Assigns will be before they're created, it goes by date ('May 19 Assign', 'May 20 Assign', etc...)</p>
  
  <p>I have a sheet that I want to link to the daily Assign. It's a straight forward VLOOKUP that I need to do to get data from the daily Assign workbook, but since it's a new file each day, I'm just wondering if there's a way to have the links update automatically to the new file?</p>
  
  <p>Thanks</p>