INDIRECT function should work for you.

Simple example of using it is if you enter file name to be referenced in A1 then you can pull data like this.

=INDIRECT("["&A1&".xls"&"]"&"Sheet1!$B$1")

This will return you data from Sheet1!B1 of file which name you have entered in A1.

Hope this will help you understand.