use central formula on many worksheets, central affect allsheets
 

i have a formula that i would like to use throughout several worksheets in my
workbook. i would like to make a single "utility" sheet where all the
formulas can be listed and then be able to use these formulas in any
worksheet in the book, rather than typing the formula each time on each
worksheet. if i change the formula in the 'utility sheet" then the formula on
all the sheets using it would have the updated formula.

I do not want the formula to refer to the cells on the "utility sheet' but
to the cells within its own sheet as though the formula was written on the
actual sheet.

thanks