If you need to consolidate the data into one grand total, you can still use the Sum function ... because you can summarize across a range of worksheets with one reference. Open the workbook ...