How do I copy columns when part of formula has another sheet in it?

I want it to formulate from row 1a, 2a, 3a, 4a, 5a, etc.
But the standard copy function goes 1a, 1b, 1c, 1d, 1e, etc.

Does this make sense?