Completely Merge Multiple Workbooks?
 

I have two workbooks that are pretty complicated and totally unlike each
other, with a lot of named ranges, separate macros, user forms, etc. I want
to build a sort of "master" workbook that will ultimately replace the other
two. To get started, I'd like to merge the two other workbooks into one, so
that the one that results contains all of the sheets, the ranges, user forms,
macros, etc. of the other two. Is there a way to do this other than dragging
or copying or recreating all of the elements from the two workbooks into the
new workbook? (This is all on XL 2003.)

I'd appreciate any advice anyone has--thanks!