Summary sheet for 10 other worksheets to auto update

I have a workbook containing 11 worksheets. 10 of the Sheets are updated by employees on a weekly basis--they use these sheets to maintain their data. Their updates consist of adding new records as well as updating existing records. I use one of the spreadsheets (#11) to pull information from the other sheets and display all of the information in that one worksheet. I do this using vlookup formulas through out the worksheet.

I would like to create a workbook for my supervisor so that employees can enter their updated records into one the 10 sheets, and the 11th sheet will automatically show all data entered. on all worksheets. The information displayed depends on a 3 digit code that resides in Column B on all of the worksheets.

Does anyone have any ideas? Thanks

isn't that what your first workbook does already?