Here is basically the problem, I have 2 sheets and want to copy/ paste them like this:

Sheet 1
Name of a product Data 1 Data 2 Data 3
A Chris Martin Ty
B John Joe Ken
C Shawn Ross Stan
Sheet 2
Name of a product Data 11 Data 22 Data 33
A Jen Ella Tina
B Martina Sue Betty
A Mary Suzy Grace
Combined Sheet 3
Name of a product Data 1 Data 2 Data 3 Data 11 Data 22 Data 33
A Chris Martin Ty
B John Joe Ken
C Shawn Ross Stan
A Jen Ella Tina
B Martina Sue Betty
A Mary Suzy Grace

Can this be done in Excell 2007? Please, any help would be great!