Drag formule from cel A1 to A2 concerning pages

Highlighted
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

 

Peter

2 Replies
Highlighted

@AnPeAnPe 

As variant

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

in A1 

Highlighted