I have 12 worksheets with total month revenue on each one, however the
salespeople is not always in the same order. I was using the formula
sum(start:endb1) etc but this does not always work because of the order they
are ranked for each month.

Is there an easy and simple way to recap all 12 sheets without defining a
name range for each sheet.

Any suggestions would help

Thanks

Fawn