I need to perform a calculation on my master sheet that will be the same and
reference the same cells across numerous worksheets, actually I will have a
series of these things.

Does anyone know how to get excel to continue performing a function until it
gets through all the worksheets and then stop (& not think it has encountered
an error)?