Create a new sheet from a template using data from another workbook

[charchar001]

Hey guys,

I am still going through other threads to get more information to potentially combine something rudimentary.

till then,
I am trying to take data from a sheet from workbook and fill in another workbook that has a master "form" template and create new sheets filled in with each data set.

I.e. of the data sheet, the column order may change with user so i would need a versatile usage? Maybe a if statement to verify that the headers match the order. Column 1 would be what drives a new sheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column 1[/TD]
[TD]Column 2[/TD]
[TD]Column 3[/TD]
[/TR]
[TR]
[TD]Op 1
[/TD]
[TD]turtle[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]op 2[/TD]
[TD]screw[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]op 3[/TD]
[TD]cup[/TD]
[TD]3994[/TD]
[/TR]
</tbody>[/TABLE]

From that data it needs to go into the form template, in which the data will need to go to a specific cell/area.
After it has filled the fields required in the first sheet (row 1 data), it creates another sheet using row 2 data.