=INDIRECT(M1&"!AB15")

where M1 has the year number.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"WLMPilot" wrote in message
...
I have a workbook with sheets named 2005, 2006, 2007. Each sheet contains
data that matches the paychecks that my wife and I get. Each column is a
paycheck. I have another worksheet called STATS. On this sheet, I have a
form for each year (worksheet) that pulls totals from each sheet in order
to
track total taxes against total income, and more. A tipical formula on
the
STATS sheet used to pull this data is obviously ='2007'AB15 (which might
be
YTD Income for one paycheck.

My question is this. How can I just have one form on the STATS sheet and
click on a command button, or something, in order to change the worksheet
reference from one year to another?

Thanks for your help,
Les