Drag formule from cel A1 to A2 concerning pages

[AnPeAnPe]

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]

@AnPeAnPe 

As variant

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

in A1 

[#3]

Thx @Sergei Baklan