Drag formule from cel A1 to A2 concerning pages

New Contributor

Hello everyone,


My problem is :


I have a reference in Sheet 1, Cel A1: ='Sheet2'!E3

I want to drag the reference in Sheet 1, Cel A2 as :  ='Sheet3'!E3 and in Sheet 1 cel A3:='Sheet4'!E3 etc etc etc.


I don't know how to drag the reference. It's concerning 100 sheets and different references at them which i want to show in sheet 1.


Please help me



2 Replies


As variant

=INDIRECT("Sheet" & ROW() +1 & "!E3")

in A1