Rollup worksheets into a master worksheet - automatically?
 

I would like to have three different people update their own product
lines within a master workbook. The master worksheet needs to retain
sorting ability. Is there a formula or macro I can use to pull this
information from three individual worksheets into the master workbook,
based on the user name? The master worksheet would then become "read
only".

* All column headers are the same
* The workbook would contain these worksheets: Master, Cathy, Laura,
Tonya

Thanks for your consideration.