Linking different cells from one sheet to another in same workbook

[John]

I've been trying to link certain cells from work sheet A, separated by 7 rows
and same column, to work sheet B. 'Summary Data'!$B$32 is an example of
the formula in sheet B but the next cell down would have to be ='Summary
Data'!$B$39, 7 cells down from the previous one.

how do I add rows to the first formula without having to modify each formula
for the next 500 cells down?

 

[Sean Timmons]

On sheet B, I would enter, say, 32 in cell A1. Then, 39 in the next, and then
fill down the number of rows you need.

Then, in another column, enter

=INDIRECT("SheetA!$B$"&A1)

and copy down!

 

[David Biddulph]

=OFFSET('Summary Data'!$B$32,(ROWS(A$1:A1)-1)*7,) and copy down.