You could use the indirect function eg:
=INDIRECT(YEAR(TODAY())&"!B5")

Note: this is a volatile function and will be recalculated everytime you
open, close, save or perform any other action on the workbook that
triggers calculation.

Hope this helps
Rowan

alymcmorland wrote:
In one of my formula's i have

'2005'!B5

This is pointed at tab sheet 2005, what i'd like to know is if it is
possible to have this in there instead:

'Current Year'!B5

and basicly translate the current year to tab sheet name so that the
refferenced tab sheet will change from year to year without anyone
having to change it?