I need to build a workbook that has a new sheet added each month. The new sheet is created from another application that produces an Excel workbook and the new sheet will be appended to the main workbook. When that's done, I need the summary sheet in the main workbook to calculate a number of things based on this new sheet, while retaining, and preferably not recalculating, calculations done for previous sheets that have been added in prior months. Yes, I could recalc everything but as the workbook grows, the recalc of every sheet is going to take too long for the overall workbook.
If that's not clear, how about a simplified example? Suppose the January sheet is appended. Now I want to calc info based on January in the first/summary sheet. When the February sheet is appended I want to calc info based on the February info but not have to re-do all of the calcs that created the summary for January.