Copy down formula issue

[NJ1000]

Hello this is the formula i would like to copy down 80 cells.

=IF(IFERROR('1'!$B$42,0),('1'!$B$42),0)

The only thing I want changing is the "1". For example, the next one would be 2 then 3 then 4 all the way to 80. 

I've tried grabbing the mini black box around and dragging down, but the formula doesn't go to the next number. 

[#2 · Accepted solution]

@NJ1000 

=IF(IFERROR(INDIRECT(ROW(A1)&"!$B$42"),0),(INDIRECT(ROW(A1)&"!$B$42")),0)

[#3]

A big thank you sir, @Patrick2788 . Your solution to the problem is most appreciated.

[#4]

@NJ1000 

You're welcome.