I have a spreadsheet that has a diffent column title every six columns. The
data for the spreadsheet is coming from a query. How can I reference the
columns that are at a constant of six columns apart? For example:

Column
A B C D E F
Part 1 XX XX XX XX Part 2

I need for the formula to reference Part 2, and subsequently Part 3 located
in column L, row 1.

Thanks, Pablo