Macro to take data and insert in a different spreadsheet

Hi everyone. Hopefully one of you can help me out. I have added an attachment to help.

In simple terms if you open the attachment, I need a macro that:

1) opens a 2nd spread sheet that contains sheet 2
2) takes data from sheet 1 and adds it to sheet 2 (sheet 3 is how sheet 2 should look after macro has added data.

Thanks in advance