Coping Formulas - Changing the Cell Reference to fit with a known pattern !!!

Dear All

To put this simply . . . . . i have created a spreadsheet containing two worksheets (sheet 1 & sheet 2)

Sheet 1 contains the following

in A1 : one
in B1 : two
in C1 : three
in A2 : four
in B2 : five
in C2 : six

Sheet 2 will reference the functions

in A1 : ="cell = " & Sheet1!A1
in A2 : ="cell = " & Sheet1!B1
in A3 : ="cell = " & Sheet1!C1

When i highlight these cells and copy them down the row value does not increment by 1 . . . in fact it increments by 3.

as a result . . . .

in A4 : ="cell = " & Sheet1!A4
in A5 : ="cell = " & Sheet1!B4
in A6 : ="cell = " & Sheet1!C4

and . . .

in A7 : ="cell = " & Sheet1!A7
in A8 : ="cell = " & Sheet1!B7
in A9 : ="cell = " & Sheet1!C7

My question is . . . how can i increment the row value by 1 and not 3 ?????

Thanks for your suggestions guys. I have managed to is the indirect function along with the cell and int funstion to achieve what i needed .