The boss has a Excel file that has 20 to 40 sheets depending on the work load. One sheet is named "totals" . All the other sheets have unique names that have the total for that sheet in F32. The totals sheet has =sum in F32 that sums all the sheets in the workbook. When sheets are added or deleted it is a manual process. Any ideas on automating this process to get totals?