Hi Fawn

have a look at Data / Consolidate this will allow you to sum values for the
salespeople without them having to be in the same order.

Cheers
JulieD

"Fawn" wrote in message
...
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