Consolidate Worksheets Wizard for Excel is an easy to use software solution designed to help users merge multiple spreadsheet documents.

This software comes as an add-in for Microsoft Excel, is easy to install, and does not need to be configured. Once the setup process is complete, users can access it from its dedicated tab.

It aims to help users automate the time-consuming and tedious task of manually merging and consolidating tables by providing them with an easy to follow, five step wizard that does away with the need to copy and paste data from one table to the other.

The wizard enables users to select between five automated methods of consolidating tables.

After users have launched the wizard, they can select which data ranges to use. This can be accomplished either by manually typing the ranges in, or selecting them from a worksheet. The wizard enables users to add multiple files, each containing multiple worksheets. Data can be selected from each of these worksheets.

The next step is selecting the method used to consolidate the data. Data can be combined and copied using one of five available methods, each of them being further customizable during the third step of the wizard.

Data can be copied from multiple ranges into a single worksheet, multiple worksheets can be combined into a single workbook, or data ranges can be combined based on their headers and contents.

Some of these methods enable users to further process the data by applying mathematical or other functions to it. This is a very handy feature that can be used to automatically, update stocks or calculate attendance, for example.

This is an easy to use and powerful software solution that can help users easily manage multiple Microsoft Excel documents by providing them with a means of combining or merging data.