Copy and paste question

[jjpacetti]

I have the following formula in a spread sheet. I would like to copy this down about 50 cells with the Sheet Number increasing by one in each new cell. How?
=Sheet2!$B$7

For example, when I copy and paste, I would like to see in each ne cell:
=Sheet3!$B$7
=Sheet4!$B$7
=Sheet5!$B$7

And so on.

Thank you for any help.

John

 

[MARK858]

What cell is the formula =Sheet2!$B$7 going in?

 

[MARK858]

One way

Book1
	A
2	AWDFG
3	1235
4	nmhj
5	pojk
Sheet1

Cell Formulas
Range	Formula
A2:A5	A2	=INDIRECT("Sheet" & ROWS($B$1:$B2) &"!$B$7")

 

[jjpacetti]

What cell is the formula =Sheet2!$B$7 going in?

Cell B2

 

[MARK858]

Then you need to amend the ROWS($B$1:$B2) in the formula I posted, change it to ROWS($C$1:$C2)

 

[jjpacetti]

One way

Book1
	A
2	AWDFG
3	1235
4	nmhj
5	pojk
Sheet1

Cell Formulas
Range	Formula
A2:A5	A2	=INDIRECT("Sheet" & ROWS($B$1:$B2) &"!$B$7")

Thank you!