Excel formula generation

Hello,
I have data spaced 264 rows apart that I need to extract from a massive mess of data. Basically, I need to tell excel to pick info from cell =C2 then cell =C266, then =C530, going down the columns I have..basically to about row C80000. This is going to be exceedingly tedious to do by hand with over 300 pieces of data I need to extract unless Excel knows to space 264 columns at a time. Is there any way I can tell Excel to skip the interim 264 rows as I create my condensed data table? If I could base the cell position off a formula, that would work wonderfully. (C[2+264*1], C[2+264*2], etc.