Use cell name/reference for in link to an external sheet in SharePoint

[fgruska]

Hello,
Is there any way to use a cell name/reference in a link to an external sheet located in SharePoint?

For example, the link is currently:

='http://moss/Data/Raw Data/[Sep10.xlsm]Summary'!L12

this works fine.
However, I'd like to keep the path name and spreadsheet name variable, means content is in a named cell, e.g. pathname and filename.

This is what I would like to get to:


='pathname[filename<FILENAME>]Summary'!L12

What function/format could I use to make this work?

Your help is very much appreciated.

Thanks,