How Do I put raw data into template and regurgitate the final merged cell product?

I have included an attachment that Im trying to set up


I need help programming this template

In the example tab I have included sample data

In the Example tab

Column A is the step number
Column C is the raw data

And Columns D and E or Columns "COLUMN1 and COLUMN2"
are stuff spit out by template


In the Compilation Tab

Starting with F5 and down is the Rawdata Table

B2 and C2 are are spit out by the Sequence Tab which does not need to be touched





I am trying to learn how to still program this


PROBLEM AT HAND:
I have provided 2 completed examples in the example tab
with S4050 and S5000


So for S5010 I want the Cells D18 to D21 merged, and the Rawdata (C18 to C21) to be put into the Compilation cell starting with F5
and the regurgitated B2 and C2 to be put in to merged cell to the right of the S5010




Is there any way to do this I have literally 1000 Pages to do and automating it would be great time saver


Thanks!