VBA code to organise data from one sheet say sheet1 to sheet2

[Power of God]

[TABLE="width: 1281"]
<tbody>[TR]
[TD][TABLE="width: 1281"]
<tbody>[TR]
[TD][/TD]
[TD]Dear all, I want to organise the data below on a different worksheet so that data for different machines in the column MACHINE is kept separately, for example Barbed wire machine No 1.(Kakuru) fault data is kept seperately in a specific column say A and the FRQ data is kept seperately under B the TYPE data under C. I want to do this for a number of machines in order to analyse the data easily.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]thanking you in advance
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 1281"]
<tbody>[TR]
[TD]T.STAMP[/TD]
[TD]NAME[/TD]
[TD]PHONE[/TD]
[TD]DEP.[/TD]
[TD]MACHINE[/TD]
[TD] TYPE[/TD]
[TD]FAULT[/TD]
[TD]OP[/TD]
[TD]FRQ[/TD]
[/TR]
[TR]
[TD]3/11/2017 14:26[/TD]
[TD]KIRABIRA JOSEPH[/TD]
[TD]O786974098[/TD]
[TD]Maintenance[/TD]
[TD]Barbed Wire Machine No. 1 (Kakuru)[/TD]
[TD]Electical[/TD]
[TD]Inverter error[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3/11/2017 14:26[/TD]
[TD]KIRABIRA JOSEPH[/TD]
[TD]O786974098[/TD]
[TD]Maintenance[/TD]
[TD]Barbed Wire Machine No. 1 (Kakuru)[/TD]
[TD]Electical[/TD]
[TD]Inverter error[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]3/11/2017 14:28[/TD]
[TD]JONATHAN SEBANAKITTA[/TD]
[TD]03124647484[/TD]
[TD]Administration/Hr[/TD]
[TD]Barbed Wire Machine No. 2 (Nyangoma)[/TD]
[TD]Electical[/TD]
[TD]Machine overheating[/TD]
[TD]Yes[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:28[/TD]
[TD]KIZITO WINAND[/TD]
[TD]0772456654[/TD]
[TD]Production[/TD]
[TD]Barbed Wire Machine No. 3 (Masiko)[/TD]
[TD]Electical[/TD]
[TD]Auxiliary Equipment failure[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:28[/TD]
[TD]KATO WINAND[/TD]
[TD]07745645467[/TD]
[TD]Production[/TD]
[TD]Barbed Wire Machine No. 4 (Kahoza)[/TD]
[TD]Electical[/TD]
[TD]Auxiliary Equipment failure[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:28[/TD]
[TD]KATO WINAND[/TD]
[TD]07745645467[/TD]
[TD]Production[/TD]
[TD]Barbed Wire Machine No. 5 (Nyamwiza)[/TD]
[TD]Electical[/TD]
[TD]Auxiliary Equipment failure[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:28[/TD]
[TD]KATO WINAND[/TD]
[TD]07745645467[/TD]
[TD]Production[/TD]
[TD]Cooling Tower[/TD]
[TD]Electical[/TD]
[TD]Auxiliary Equipment failure[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:29[/TD]
[TD]KATO WINAND[/TD]
[TD]07745645467[/TD]
[TD]Production[/TD]
[TD]Expanded Metal Machine(Babirye)[/TD]
[TD]Electical[/TD]
[TD]Auxiliary Equipment failure[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:29[/TD]
[TD]KATO WINAND[/TD]
[TD]07745645467[/TD]
[TD]Production[/TD]
[TD]Barbed Wire Machine No. 4 (Kahoza)[/TD]
[TD]Electical[/TD]
[TD]Burnt electrical gadget[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:29[/TD]
[TD]KATO WINAND[/TD]
[TD]07745645467[/TD]
[TD]Production[/TD]
[TD]Corrugated Roll Forming Machine 1[/TD]
[TD]Electical[/TD]
[TD]Burnt electrical gadget[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]7/11/2017 10:30[/TD]
[TD]KATO WINAND[/TD]
[TD]07745645467[/TD]
[TD]Production[/TD]
[TD]Barbed Wire Machine No. 5 (Nyamwiza)[/TD]
[TD]Electical[/TD]
[TD]Burnt electrical gadget[/TD]
[TD]Yes[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]