copy entire sheet from closed workbook and insert into another workboook when opened

Hello everyone.

I'm hoping you can assist me.

I have 2 workbooks. What I want to do, is when one workbook is opened it will run a macro (on open) that goes to a closed workbook, copies a sheet from it and then inserts that sheets information into a sheet in the now open workbook.

I'm completely new to this so your assistance, patience and understanding would be greatly appreciated.

Cheers
Mike