Copy cells from one sheet to another

[macro_beta]

I'm looking for a macro that can help me copy a row from a sheet to another one. Simple as it might sound, is a little bit more complicated.

I have two sheets one has the raw data and the second one has report format.I will like to run a macro in the sheet looking for cells with a particular customers name and them copy those rows into the second sheet that has fewer columns as it a more easy to follow report.

So in the first sheet i have 12 columns headers and on the second i only have 6.

I'm attaching a sample format, if anyone can help will be great.

I've tried many macros and formulas unfortunately haven't found the solution.