Build listings or tables with information coming from spreadsheets of different books. The columns allignment is automatic.
Consolidate data of spreadsheets with different structures
How to consolidate data of multiple Excel spreadsheets
QuickRows is an Excel add-in that allows you to merge multiple spreadsheets (even with different structures) into a single consolidated table. This way you can analyze and interpret your data easily.