I think the relative and absolute reference would help you with this.
There are 3 types of them:
$A1 Allows the row reference to change, but not the column reference.
A$1 Allows the column reference to change, but not the row reference.
$A$1 Allows neither the column nor the row reference to change.
In your case, I think you only want the column ...