Sheet1!$A$1, next reference should be Sheet2!$A$1

[Marcin4111]

Hello,
In collective worksheet, "1" row is referenced to Sheet1!$A$1.
I want to create a button to reference rows "2, 3, 4, ...", to: Sheet2!$A$1, Sheet3!$A$1, Sheet4!$A$1, ...

Is it possible to reference it with formula or should I use macro?

Regards,
Marcin

 

[MixedUpExcel]

Hi Marcin,

Would a formula like this help if you have it in cell A2 on Sheet 1:

=INDIRECT("Sheet"&ROW()&"!$A$1",1)

Then you can drag it down into A3 and then A4 and so on and it will reference the next Sheet, eg. Sheet 3 and then Sheet 4.

Thanks.

Simon