Find lowest and the highest values across the sheets and enter into cell

Even worse, it doesn't update via Sheet Activate event.

I think better close this and open a new thread disclosing everything that you are trying to do in the first place.