XL97: The Workbook Consolidation Wizard

SUMMARY

This article describes how to download the Workbook Consolidation Wizard, which is an add-in program for Microsoft Excel 97 that you can use to consolidate worksheets from one or more workbooks into a single master workbook.

Currently the only way to perform this task is to use the Move Or Copy Sheet command on the Edit menu, manually copy the sheets and then paste them, or drag the sheets from one workbook to another one. These methods may require a significant amount of time if you want to consolidate many workbooks or worksheets. Using the Workbook Consolidation Wizard is more efficient than using a manual method because the wizard contains options that make consolidating workbooks easier.