Vlookup - Link external filename to a cell and apply to formula?

Hi Everybody! I had a hard time figuring out what to title this post, so bear with me while I explain what I need to do. I work in an office where we receive large spreadsheets of data on a monthly basis. Creating the Vlookup formula for the information I needed was easy enough, but what I want to do is to be able to type a file path and array information into a cell and link that cell to the table array section of the Vlookup function.

For Example:

Cell F5 will have: 'C:\Users\JohnSmith\Desktop\[January.xlsx]Sheet1'!$A$2:$H$14

Then instead of placing that whole string into the Table Array section of the Vlookup function, I want to just source cell F5

So it would look something like: =VLOOKUP(B11,F5, 5, FALSE) <--- but of course that doesn't work :-(

Is there a way to make this work?