If you copy your formulas down the row part of the references can't
change because the have a $-sign in front of them.

If you want the Column parts to be adapted automatically I would
suggest you copy the formulas as follows

Formula in B4: ='Production Output'!D$21

B4 -- D4
D4 -- F4
F4 -- H4

Then you MOVE

D4 to B5
F4 to B6
H4 to B7

Is that the end of the story or do you then want to copy that block
elsewhere?

Hans