copying a formula when the referenced data is not adjacent

[Jeff Donahue]

I have a set of data on one sheet that is arranged with
related types of data every 10 rows. So my swim data is
in cells

A1 1500 yds
A11 1000 yds
A21 2000 yds
A31 3500 yds

They are always a certain length apart.

what I am trying to do on another sheet is to reference
this data in one group. So that I can pull in this data
so that it they are adjacent to each other. So basically
on the next sheet I want it to be:

In cell C1 I want =A1
In cell C2 I want =A11
In cell C4 I want =A21
etc...

Is there an easy way to copy get this without having to
link each cell individually. I have tried copying the
cell down but it just gives me a1, a2, a3, etc... instead
of what I want.

 

[J.E. McGimpsey]

One way:

C1: =INDEX(Sheet1!A:A, (ROW()-1)*10+1)

Copy down as far as desired.