Hi!

Try this:

=INDIRECT("Sheet"&ROW(A1)&"!A1")

Biff

wrote in message
oups.com...
I have a workbook with 31 worksheets. I want to use the formula
=Sheet2!$a$1 and be able to drag it down with the sheet number
incrementing to =sheet31!$a$1. Is there a way to do this?