Use Data from Non-Consecutive Rows into consecutive rows on different worksheet

Hi there,

I'm looking to find a formula that will take every 16th row's cell value, and use it in consecutive rows in a different worksheet.

The attached illustrates what I mean.

I'm looking to build a table in sheet1 to show the year end values, based on the info in sheet2.

Basically cell B2 in sheet 1 should equal the value of cell n28 of sheet 2, then cell B3 in sheet 1 should equal the value of cell N44 of sheet 2.

Is there a way I can do this easily? I'm really looking for the rationale behind this so I can apply it to any other case like this.

Many thanks.

Try:

=INDEX(Sheet2!N:N,16*(ROWS($A$1:A1)-1)+28)

copied down