Simple Column formula.. should be anyway.. but drawing a blank!

Good afternoon,

I have two sheets, the first sheet is picking up data from the second sheet.

Data in the second sheet has coloumns Jan to Dec, for 20 years; ie 12 coloumns x 20 = 240 coloumns

In The first sheet, i want to be able to pick up January values only.. Instead of linking each cell manually.. how can this be done? IE: Pickup up cell A1, then the next cell picks up A13, then A25, etc etc..

I'm sure its a simple thing and its explained somewhere before, but i dont know what to search for..

Many thanks

Sam

Maybe something like this:

If you have your column headers in row 1 and the data you want in row 2

=HLOOKUP("January",INDIRECT(ADDRESS(1,1+(COLUMN(A1)-1)*12) & ":" & ADDRESS(2,12+(COLUMN(A1)-1)*12)),2)
in A3 and drag across

Cheers. that sorts out the problem.