I'm looking an optimal way to consolidate data from multiple (identical) worksheets into a one master sheet. The issue here is that the user may add or delete the (identical) sheets any time and rename those sheet(s) to any name they want.
Currently I have used two empty sheets named 'First' and 'Last' and required the user to enter the new sheets between those two sheets. Then I have used the formula in the master sheet like =SUM('First:Last'!A1) to sum cell A1 over those sheets.
This works but is it the best approach? I'd prefer not to put any extra empty sheets to workbook if there is a better way. I use Excel 2007 and 2010, if that makes any difference.
Currently I have used two empty sheets named 'First' and 'Last' and required the user to enter the new sheets between those two sheets. Then I have used the formula in the master sheet like =SUM('First:Last'!A1) to sum cell A1 over those sheets.
This works but is it the best approach? I'd prefer not to put any extra empty sheets to workbook if there is a better way. I use Excel 2007 and 2010, if that makes any difference.
