Macro - Combine/Insert Sheet

Hi

- can anyone help?

I have two sheets (1 & 2) within an excel file and I wish to run a macro to pull the results of sheet 1 into the other, sheet 2.

Sheet 1 may vary in size & length so I want to copy all of the used-range(?) but move down the text following so that it is beneath the inserted sheet.

I attach an example of the sheets and an end result sheet.

My knowledge of macros is very limited

Thanks

Obviously so is my attachment knowledge!

Additional request for help...

If anyone is able to help - with the macro, could it specifically look for 'sheet1' as it will be in a document with about 6 other sheets?

Thanks