Referencing every other column from another worksheet?

[jcooklsu]

Worksheet 1 features a series of data columns a&b for each month. ie CG= A Feb, CH= B Feb, CI= A March, CJ=B March, etc.. thru CN

On a separate worksheet I need to reference the data from the A columns with a draggable formula where for example A1=A Feb, B1= A March, C1= A April.

I've tried googling but haven't been able to find a solution that works.

Thank You

[Pete_UK]

Try this in A1:

=INDEX(Sheet1!$CG2:$CN2,(COLUMNS($A:A)-1)*2+1)

then copy across.

Hope this helps.

Pete