Quick way of copying cell references but referecing different rows

[TomP1988]

Apologies, I probably haven't explained this very well in my heading.

I have two spreadsheets, one containing lots of resourcing data and the other summing them by team / project.

In my data sheeet I have about 50 projects all configured in exactly the same way. There are fifteen rows per project (a project name and then 14 different technical teams) with a row space between projects.

In my summary sheet I am referencing the data sheet. As my project / team rows are always 16 rows apart, I wondered if there's a way of just copying the formula above but adding 16 rows to it.

So in one cell I reference

=Sheet1!B41

and in the next I reference

=Sheet1!B41 + 16 rows = B57

Is this possible? Thanks in advance

[TomP1988]

I think I can do this using the OFFSET function but just can't work out how to use it...

[GaryBarlow]

Something like:

=INDIRECT("Sheet1!B"&(ROW()*16)+25)

Entered in A1 and copied down...?