Formula that changes sheets every row

[Sworks]

Hi quite a simple one but not found a solution anywhere so far.

I have a bunch of sheets all containing data

I have a master sheet which has a formula =Sheet1!A1

I would like to drag that formula down so that for every row the formula goes =SheetX+1!A1 but I have not figured out how to

Essentially every row is the A1 cell of a different sheet.

Thanks

S

 

[Marc L]

Hi,​

​

as you forgot to indicate the cell address where this formula is but you can see the VBA help of INDIRECT worksheet function …​