Merge workbook to single workbook

[soundu8765]

I want to merge 2 workbooks for ex. sheet 1 of 1st workbook and sheet1 of 2nd workbook to a new workbook in the sheet 1.
CAn someone please provide me the code for merging.