OK, let's try again.  I am in 1 workbook. I am trying to take 1 cell in 1
worksheest that has a function of summing a cloumn of about 10 cells.  I want
that auto sum to show up in a different worksheet.  I want the updated total
to reflect in both cells without having to go throught the update cycle of
closing the workbook, etc.

Please help.