Formula to Add Movement to a Cell

I have a form on Excel where the info shows up every 55 rows that I would like to put on another spread sheet.

Is there a formula where I can, say, start with A1 in the new spreadsheet and type ='Book1'!B6 and than in B1 of the new spreadsheet type something that what show me the data in B61?

Thanks!

Try:

=INDEX('Book1 '!$B$6:$B$1000,55*(COLUMNS($A$1:A$1)-1)+1)

adjust B6:B1000 to your whole range... and copy across from A1 to B1, etc...

is there a space after Book1 in your sheetname? Check that, please.

Try:

=INDEX('Book1 '!$B$6:$B$1000,55*(ROWS($A$1:$A1)-1)+1)

copied down.