Link workbooks Dynamically from multiple cell values

[2k05gt]

I have a workbook that get built every week (Work Status) the previous weekly status workbooks are saved on a network share.

I am trying to Dynamically change the workbooks name and retrieve Cell values from the previously saved workbook.

Previously saved Workbook: Weekly Status (20170701).xlsx
Workbook: Weekly Status (20170707).xlsx

If you manually link the cell this is what it looks like

='E:\Status\[Weekly Status (20170701).xlsx]"&"STATUS'!"$H4


But I need it to change the date from value in cell $F$1 (previous date request)

I have named fields "FileLoc" = the network Path

I tried this but get a #REF error

=(INDIRECT("'"&FileLoc&"[Weekly Status ("&$F$1&").xlsx]"&"STATUS'!"&$H4)


Any Ideas what I am doing wrong?