Using dynamic named ranges from another workbook inside a formula

[SHUTTEHFACE]

Hi all,

I'm trying to use a named range in another workbook inside my index match formula. Because the location of the file will change based on who is accessing it, I have a cell using the CELL("filename") formula to determine the path of the file.This gives me:

C:\Users\SHUTTEHFACE\Dropbox\ABC\ABCdocs\123\[filename.xlsx]Data

I'm then using CONCATENATE to get the proper reference nomenclature for excel:

'C:\Users\SHUTTEHFACE\Dropbox \ABC\ABCdocs\123\[filename.xlsx]Data'!

[filename.xlsx]Data'!

contains a bunch of dynamic named ranges I'd like to use inside my INDEX MATCH Formulas. First off, is this possible? Second, how would I do this?

Cheers,

STF