Referencing every 2nd row from one sheet into another

[needhelpthanks]

Hello,
I need to know how to reference every 2nd row from one sheet, and call it in a column in another sheet in the same workbook. Also, is it possible to nest this function within a larger function?

[Special-K]

in Sheet2!B2
=INDEX(Sheet1!C$1:C$100,ROW()*2-1,1)
copy down as far as B8

[needhelpthanks]

Can you explain what that formula means exactly and if it is possible to nest it? I found that formula online but it was not working for me.

[Special-K]

Your date in Sheet1 is on rows 3 5 7 9 11 etc
You want the data to got on Sheet2 rows 2 3 4 5 6 etc
The increase in rows is linear therefore you can use y=mx+c to calculate the row you want it to go on.

As each Sheet2!row increases by 1, the originatin row on Sheet1 will increase by 2.
Sheet2! ROW number x2 -1 gives 3 the originating row on Sheet1

Just use a simple INDEX to pull the original value from Sheet1 or google Excel INDEX

(I havent explained this very well as I'm off to lunch in few mins).