I've transposed the information from one worksheet to a second worksheet in
order to see the information linearly. The cells are referenced directly,
but in the original document, everything is in the same line.

Basically, I want all the cells in rows 2-8 of the new worksheet to be
referenced to row 2 of the old worksheet; rows 9-15 of the new to be
referenced to row 3 of the old, etc. When I copy/paste, instead of using row
3 (of the old), it uses row 9. Same goes when I try to use row 4, it uses
row 16. Is there any way to preserve that?

If more clarification is needed, I can do so, or even provide a link to the
file of what I'm trying to do.