We can see the layout of an individual 1 #xx Coin sheet that you've posted
no doubt the layout of the 2 & 3 #xx Coin sheets are different.

How about if in the Individual sample(s), for each column you give the row number of the Revenue cell to be copied ?

I suspect macros are the way to go with this but consistency is essential.
Hopefully there are only 3 templates to deal with.