Data across worksheets

Is it possible to enter a formula in the format of, "='Sheet1'!A1" and then
just click and drag and have the formula automatically go the the next sheet?
i.e "='Sheet2'!A1" instead of "='Sheet1'!A2"

an indirect function can do this with a little manipulation
if you start in row 3 for example
=indirect("'Sheet"&row()-2&"'!A1")
and copy this equation down it should do what you want.

"nelsquid" wrote:

> Is it possible to enter a formula in the format of, "='Sheet1'!A1" and then
> just click and drag and have the formula automatically go the the next sheet?
> i.e "='Sheet2'!A1" instead of "='Sheet1'!A2"