How do you consolidate two MS Excel files into one file?

you can put two in the same workbook by right clicking on the sheet icon and inserting, otherwise, be more specific please