I have a workbook that will be used by several others. I need to find a way
to get totals from each sheet and add them together on the "Overview" sheet.
For example, on Overview sheet Cell C5 might have
='Account1!AF100+'Account2'!AF100+'Account3'!AF100 +'Account4'!AF100

The issue I am having is that each user of this sheet will have a different
number of "Account?" sheets and there will be no naming consistancy as they
would put the actual account name for the sheet name.

Is there a way to simply do this or else what is the best programatically
way to accomplish this?

Thanks,
BradK