Hi
you may use the function INDIRECT. e.g. if you store the sheetname in
cell A1 you can use it as follows:
=INDIRECT("'" & A1 & "'!A1)
(note the multiple apostophes at the beginning and in the middle: " ' "
and " ' !)

--
Regards
Frank Kabel
Frankfurt, Germany

Minitman wrote:
Greetings,

I have a formula that is looking at a named range (Sheet1!A1) from
Sheet2. I need to add 19 more sheets (Sheet3 thu Sheet21). Is there
anyway to change which named range that formula is looking at?

TIA

-Minitman