Merge workbooks

[Jeff Gentry]

I have two workbooks. One workbook is named jeff and contains sheet names one, two and three and the second workbook is named Jim and contains sheet names four, five and six. How do I merge the two workbooks into one workbook and keep all six sheets? All of research has yielded results on how to merge multiple sheets into one sheet but I haven't found anything that allows me to merge workbooks but keep each separate sheet.

 

[VoG]

This may help you http://msdn.microsoft.com/en-us/library/cc837974.aspx