I use Excel for costing manufacturing jobs, with workbooks running into varying numbers of sheets, all duplicated from the first.
What I need to do is produce a summary sheet which totals various cells from each of the other sheets.
Can you advise the best way to do this.
If the summaries will draw from all of the same cells, then an easy way to do this is to label two worksheets "First" and "Last" (be sure to keep them blank). Then put all of your worksheets between those two worksheets, and the "Summary" worksheet before the "First" worksheet.
Then on the "Summary" worksheet you can use formulas such as:
in cell A3 put this formula =SUM(First:Last!A3), which sums every A3 cell in every worksheet that is in between First and Last.
Thus, if you add more sheets between First and Last, you never have to change the formulas.
old, slow, and confused
but at least I'm inconsistent!