Is there a way to fill a formula across columns (i.e., horizontally) but have the cell references in the formula increment the row number instead of the column?

I have a summary sheet that links to totals on back-sheets and this would speed up the linking of cells. Lets say A1's formula is `=Sheet2!G5`

. I want the value of B1 to be equal to `=Sheet2!G6`

and NOT `=Sheet2!H5`

.

How can I get Excel to do this?

Clarification

Each row on my summary sheet needs to pick-up 3 values from a back-sheet.

A1

`=Sheet2!G5`

B1 `=Sheet2!G6`

C1 `=Sheet2!G7`

A2

`=Sheet3!G25`

B2 `=Sheet3!G26`

C2 `=Sheet3!G27`

I would like to save time by only manually setting A1 `=Sheet2!G5`

and A2 `=Sheet3!G25`

then somehow offsetting the values in B1,C1, B2, C2.

`=Sheet2!G50`

,`=Sheet2!G51`

, and`=Sheet2!GH52`

. I assume that thein`H`

`GH52`

is a typo. (2) Please explain what you've done to your "summary sheet" to cause`A1`

-`A2`

-`A3`

to be aligned horizontally. Please do not respond in comments; edit your question to make it clearer.