Continue auto fill across multiple columns?

I'm sorry yeah I didn't explain very well let me try a little more complex..

I have two sheets "Totals" and "Report"

The "Report" sheet is a print out from a program we use that has about ten columns of info but I only need to use column and A and C, that is a rolling 30 day period, Column A is number of minutes of business, and C is the number of employees we would need to be most productive.

On the sheet "Totals" I have four sets of three columns each that represent weeks separated by one blank column. (Columns A,B,C is week 1/ D is blank / E,F,G is week 2 / H is blank etc.

The 1st column in each set is just equal to the report of customers so =report!a1, column 2 is irrelevant and used for a different formula, but column 3 I have =LOOKUP(a1,report!$a1,report!$c1) so that it looks up the value in the same row, and gives me the number in column C on the reports page, this works fine, however the reports tab just has a dump of info for the whole month, and I want to break that down into weeks on the "totals" tab. To do that I have =LOOKUP(a1,report!$a1,report!$c1) in Column C, and used the fill handle down to 50 so the last formula in cell C50 is =LOOKUP(a1,report!$a50,report!$c50), Is there anyway to have cell G1 in the second set automatically start at row 51 on the report page?

Why do you use a Lookup function at all? You could just as well use =report!C1 and copy down. Manually adjust to =report!C51 in G1 and copy down.

It is possible to use formulas to increment by 50 every four columns, but that would be way more complex than just editing the cell reference.

OK, on the Totals sheet in cell A1 use this. Copy the same formula to E1, I1, M1, etc.

=INDEX(Report!$A:$A,((COLUMN()-1)/4)*50+ROW())

In cell C1 and in G1, K1, O1, etc use

=INDEX(Report!$C:$C,((COLUMN()-3)/4)*50+ROW())