When you have a column of data and you want to drag down an equation, how do you keep it from skipping rows?

Ex: Cells A1-A5 are merged. Cell(A1-A5)=Sheet1!A2, and I want cell (A6-A10) to yeild Sheet1!A3. Is that possible? I hate merged cells...