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

Name	1A	1B	1C	2A	2B	2C	3A	3B	3C
A1	ABC1	y1	x1/z1	ABC2	y2	x2/z2	ABC3	y3	x3/z3
A2
A3
A4

<tbody>
</tbody>

Worksheet name "A1"

Name	Total Count	%	1st
ABC1	x1	y1	z1
ABC2	x2	y2	z2
ABC3	x3	y3	z3

<tbody>
</tbody>

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!