To link to a sheet or workbook whose name is variable you could use the
INDIRECT function - but then the source workbook has to be open.
If that is not a suitable solution you could change the link sources in
an Auto_Open macro.

If you need further help, please indicate which type of solution you
prefer and give the names (or naming schemes) of the workbooks and
sheets concerned.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup