I have information (numbers) ranging on Sheet1A1 to Sheet1GS1.

I would like to copy these numbers onto Sheet2 ranging from A1 to A150.

I enter =Sheet1A1 on Sheet2A1, and then enter =Sheet1B1 on Sheet2A2.

When I try to Autofill, I would like the results to show =Sheet1C1 on
Sheet2A3 all the way down Sheet2. However, when I try to autofill the
program will not keep the pattern I have written above. What can I do to
make the autofill follow my pattern?