Adding numbers to cell references in formula, rather than cell values

Hi there,

I currently have text inputs in cells A1, AA1, AB1, AC1 etc.
I would like cells A2, B2, C2, D2 etc. to show these text inputs.

Is it possible to add a number to the cell reference rather than the cell formula which directs the B2 to look 26 cells to the right of cell A1?

Any help is greatly appreciated.