One way:

Make the linked-to cells a named range (select the cell(s) and enter the
name in the Name Box at the left side of the formula bar).

Then instead of

=SUM('[Workbook1.xls]Sheet 1'!A1:J10)

use

=SUM(Workbook1.xls!MyNamedRange)


In article ,
Bed wrote:

I need to link two worksheets in seperate files together. The problem is the
tabname on the first worksheet changes everyday. Is there a keyword I can use
to identify the 1st worksheet regardless of its "name"?