Copy data from multiple sheet into one master sheet

[Koxeida]

Hey guys,

I'm trying to copy data from multiple sheets into the main "Mastersheet". Assume Name is at Cells.A1.


Mastersheet
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]1A[/TD]
[TD]1B[/TD]
[TD]1C[/TD]
[TD]2A[/TD]
[TD]2B[/TD]
[TD]2C[/TD]
[TD]3A[/TD]
[TD]3B[/TD]
[TD]3C[/TD]
[/TR]
[TR]
[TD]A1[/TD]
[TD]ABC1[/TD]
[TD]y1[/TD]
[TD]x1/z1[/TD]
[TD]ABC2[/TD]
[TD]y2[/TD]
[TD]x2/z2[/TD]
[TD]ABC3[/TD]
[TD]y3[/TD]
[TD]x3/z3[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Worksheet name "A1"
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Total Count[/TD]
[TD]%[/TD]
[TD]1st[/TD]
[/TR]
[TR]
[TD]ABC1[/TD]
[TD]x1[/TD]
[TD]y1[/TD]
[TD]z1[/TD]
[/TR]
[TR]
[TD]ABC2[/TD]
[TD]x2[/TD]
[TD]y2[/TD]
[TD]z2[/TD]
[/TR]
[TR]
[TD]ABC3[/TD]
[TD]x3[/TD]
[TD]y3[/TD]
[TD]z3[/TD]
[/TR]
</tbody>[/TABLE]

Basically I'm trying to copy data from all the worksheet (aside from Mastersheet) into the Mastersheet as shown above.

One thing to note is that in the column D (named "1C) I'm trying to do a simple calculation as stated in the cell.

Thanks in advance!