check out the indirect() function.
I am not sure what you want to do with it, but think this will work.

"Kenton_SJ" wrote:

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.