reference to a sheet

I want to make a way to get a value from a especific sheet=20
that changes with year. Lets say I have a file=20
(spreadsheet) with four sheets (2005,2004, 2003, 2002) and=20
I need a value from 2004 sheet if I=B4m in year 2004, and=20
from sheet 2005 if i=B4m in 2005 year. It means an indirect=20
reference to a field. I can make indirect references to=20
files and fields but I findn=B4t a way to make an indirect=20
reference to a sheet

Hi
try
=INDIRECT("'" & YEAR(TODAY()) & "'!A1")

--
Regards
Frank Kabel
Frankfurt, Germany


Braga Luiz wrote:
I want to make a way to get a value from a especific sheet
that changes with year. Lets say I have a file
(spreadsheet) with four sheets (2005,2004, 2003, 2002) and
I need a value from 2004 sheet if I´m in year 2004, and
from sheet 2005 if i´m in 2005 year. It means an indirect
reference to a field. I can make indirect references to
files and fields but I findn´t a way to make an indirect
reference to a sheet