Using Excel, how can I update content in multiple sheets automatically?

Very simple. If you want to enter the same information into the same cell on multiple worksheets then all you have to do is group the worksheets by clicking each of the unhighlighted sheets whilst holding down the ctrl key.When finished make sure that you un-group the worksheets. Good Luck