Autofill horizontally while maintaining formulas

[pittsburghr2]

I have three columns: A1 references a cell from another sheet - let's say Sheet2!A1. B1 has a formula based on A1. C1 has a formula based on B1. I need to repeat these three cells, as a group, horizontally over and over. So when I select them as a group and autofill to the right, the B1 & C1 cells behave like I want them to - but the cell reference in A1 increases based on the number of cells it moves to the right. In other words Sheet2!A1 becomes Sheet2!D1 - when what I want is to have it be Sheet2!B1 (even though it's now in Column D).

Is there a way to autofill these three cells to the right AND have the column reference in the first cell only increase by 1 to B, C, D, etc. each time? Hopefully this makes some sense.

Thanks.

[FDibbins]

Hi, welcome to the forum

You may need to adjust the row ref (bolded part), but try this......
=INDIRECT(CHAR(96+INT(COLUMN(A1)/3+1))&4)