Spreadsheet Consolidator is an Excel add-in which will allow to consolidate spreadsheet data from one or several sheets from one or many open workbooks, easily and quickly.
Spreadsheet Consolidator is a part of Model Assistant Suite (which will be released soon).
http://www.modeladvisor.com/erol.html#747x4133