xCollator

xCollator automatically pulls data from multiple spreadsheets and collates that data into one easy-to-use file. You can then load this file into Excel, Access or another database for analysis or storage.

Specifying what data you would like to collect with xCollator is a simple as right-clicking on the relevant cells in your Excel workbook. xCollator will save your selections to a map file, which can be reused as many times as you need.Once you have a map file, you point xCollator to the directory that contains all of your spreadsheets. xCollator will go through each of the spreadsheets in that directory and use your map to gather your data. When this is complete, xCollator will show you your combined data file.