Summarize Data from 27 Spreadsheets in One Workbook

[Chris Waller]

I have an Excel 2010 Workbook which contains approximately 27 Spreadsheets and I need to summarize the data onto a summary sheet. Some of the data is financial and the other data is purely numeric. All the data is contained on row 12 starting from Column E. I am looking for the easiest\best way to do this as the data on the spreadsheets expand I need to include the new figures. The only way I can think of, of doing this is to use the SUMPRODUCT formula, however there may be a better way of achieving the same end. I will try and attach a spreadsheet which I am hoping will make matters a little clearer. For example where the invoice number is the same I need to be able to total all the relevant figures and give a total that will update. The information on row 18 and 19 would appear on a separate spreadsheet within the workbook. TIA