In one sheet I need to reference cells in a different sheet in the
same workbook. It's a long sheet of projections, so it would save me
lots of time if I could use AutoFill to add references to the cells on
the other sheet.

The cells I want to reference are in the same row, but they're not in
adjacent columns- specifically, they're located in every 5th. column
(i.e. A2, E2, I2, etc.) If I start with a reference to A2 and use
AutoFill, I get B2, C2, D2, etc. Is there any way to specify the
realtivity of AutoFill to use every xth. row or xth. column?