Excel 2007 : Generating a master spreadsheet from 9 sub sheets

I'm an Excel amateur in need of some professional help. Here's the situation:

I have a workbook set up that's going to be on a shared drive so that people from several different locations can add information to it. Each person will add information only to his or her own location (different sheets for different locations). I have all of the individual tabs for the different locations set up; what I want now is for a master sheet to automatically populate itself with all of the information from the various locations, and update itself as the different sheets are modified.

I have the file attached with some bogus information already input, so that if someone would be *ever-so-kind* as to draw up a test for me, nothing additional will need to be input into the sheets for the different locations.

Thank you in advance for any help and suggestions!