I have two unrelated workbooks, each with multiple sheets with multi sheet
references. I like these references and in creating a new workbook, would
like to combine the unrelated workbooks. The combine (merge and compare)
option is not allowed by excel.

If I copy the sheets, one by one, the new sheets references to one another
will be lost. What do I do?