I have a workbook consisting of 2 sheets (1 form and 1 database lists) many forms and macros that forms the base form for some accounting functions at the corporate level. There are 2 companies that have appended extra sheets, forms and macros onto the base workbook The problem comes form change.

What is the best way to handle it. I have some VBA code which broken each of them into their components and can build them back. The problem is the sheets. Moving and copying the sheets gives me a bunch of links to the original SS for cell references and range names.

Is there a better way to handle this?