Using auto-fill with a "formula"

[cpgoose]

Hi folks...any help with this would be great...

I have an excel file with 2 sheets. Sheet "one" has the raw data, and sheet "two" is displaying the data readable manner. Sheet one has data about students such as their ID, first and last name, address, etc. Sheet one is also a csv file, so the first row of data are the headings (like name, address, etc). So Column A, for example, is ID. So A1 = "ID", A2 = 100, A2 = 302, A3 = 340, and so on (no particular order).

I'm trying to use autofill to fill the rest of sheet two, but it's not working properly. I'm picking and choosing the info from "one" to display it in "two", so I'm wondering if that's why it's having a problem.

For example, in sheet two, cell a1, I have the following: =one!A1. It will properly display "ID". If I write the following in b2: =one!A2, it will write 100, which is also right.

See attached. As soon as I do an autofill (see the text in red in C1 or A4 or B4) it does the fill wrong.

Any ideas? Thanks!!