Using INDIRECT to search a closed file

Hi all,
I recently posted here about doing a LOOKUP combined with a INDIRECT to look on multiple colunms (solved) but now i need to perform a similar task acros more than one file.

A1 B1 C1
1900 S:\Folder\Takeway\[Food FY15 WK1.xlsx]WK1'!$C$52 #REF!


A1 = Desired cell figure (using ='S:\Folder\Takeaway\[Food FY15 WK1.xlsx]WK1'!$C$52)
But when i use C2 to INDIRECT search B1 for the exact same text it returns #REF!

What am i doing wrong?