Convert date into filename for linking cell to another file

Hello,

I am trying to link a cell on my main spreadsheet to an external workbook, but want to change which workbook depending on which date i enter on my main spreadsheet.
All the source workbooks are in the same filepath, their names are in d-m-yyyy format.

Ive attached a spreadsheet showing my thinking so far.

Thank you

The format changes from m-d to mm-dd as needed depending on the date. I set it up in my example spreadsheet that way. If you enter a date in the highlighted field, it gets converted to the proper format in D7
Im at the point now where i need to tell excel that the text in D7 is the filename, and the text in E7 is the filepath

Using concatenate i get my complete file extension as 'S:\My Documents\[5-9-2017.xlsx]Sheet1'!$A$1
So this is where my source data is located. How to i get excel to execute that command? If i do equals to the concatenate cell in another cell it just copies over the file extension as text

Ive attached the workbook im working on along with two example source files with dates 5/9/17 and 4/30/17

Where i have the #REF! error should be where im automatically linking to those workbooks when i change the date in the highlighted field.

Can this be achieved through VBA?