If your original formulas might be:

=SUM([2002.xls]Sheet1!$B$1:$B$10)
=SUM([2003.xls]Sheet1!$B$1:$B$10)

Then use, say D1, to enter your WB name (2002, 2003, ... etc.)
And try this:

=SUM(INDIRECT("["&D1&".xls]sheet1!$B1:$B10"))

NOW, this *only* works when the other WBs are *open*.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Kenton_SJ" wrote in message
...
Basically I have a yearly work book that maintains a record of my daily
activities. I'm am making a summary workbook that links to my yearly
ones.
I'd like to be able to type in the year and then a formula changes the
link
to the year number. My workbooks are called 2002, 2003, 2004.... I can
get
it to link fine when I type in the filename, but I'm not sure if it is
possible to get a formula to do the same.

Thanks.