Creating a master sheet referenced to multiple worksheets
 

I currently have an Excel document with numerous records for various products
containing information regarding product type, model year, concern, failure
mode, etc. Because each product is handled by a different person, I would
like to split each product into a separate sheet but allow anyone to search
for information based on any of the entered information on a 'master sheet'.
Very similar to the way the 'AutoFilter' option works on individual sheets.
The reason I would like to split the products is to give everyone their own
sheet to update and not have data for products spread around a single sheet.

Thus, if anyone has any input on how to create a master sheet with drop down
lists created by all the informaiton on other sheets, that would be great.
--
Thanks

John