Is there anyway to add totals of a particular row in a worksheet that can
change position in another worksheet and add the totals in a master sheet.
(I am making a roster and adding peoples shifts however sometimes I need to
add people to the list in various positions replacing others)
I know to use the offset or sumproduct formulas in each individual sheet but
don't know how to add all the sheets into a master.

Thanks
Graeme