I would appreciate learning how to construct a formula or function that would allow me to create, on a summary worksheet, a SUM total of cell entries on 40 plus worksheets in the same workbook, which entries are all in identical positions on the sheets. So I'd like to retrieve and SUM, for example, all 40 cell B24s, into a cell on the summary sheet. The need arises since the 40 worksheets were originals produced without the now needed category as part of the summary sheet. I'd like to avoid having to do the tedious job of creating a new report column of all the needed data, by going back and forth, summary to individual sheets to create cell reference formulas. Thanks in advance for advice.