Create Mirror Columns from Similar Sheets tool auto-scans all the candidate columns and mirrors them in a single operation. Simply choose a source column as a reference, and set up matching rules (including the search scope and column matching restrictions), this tool will then search across similar-structure worksheets to find the matching columns, and batch-create mirror columns into one destination worksheet.

It is a handy tool when your expermental data is scattered across multiple books and you need to collect the interested datasets into one place for processing, plotting or side-by-side comparison.

Select menu Worksheet: Create Mirror Columns from Similar Sheets to open this tool.