How do I get one worksheet to update when others change?

[Bdubs]

I work at a bank and am responsible for updating possible loans. Each
officer enters his/her personal loan info into a seperate WS, the totals of
each officer are then rolled into a summary WS. Is there a way so that the
summary WS updates as the individual officers change their individual
worksheets?

 

[Barb Reinhardt]

Are the worksheets in the same workbook or separate workbooks?