Updating a worksheet automatically?

You would have to create a macro or event handler to loop through all sheets and tally the data needed.