if the shhets are filled out the same you could link directly to the cells
you want showing up on your master sheet.In your master shhet in "johns"
column type = then click on the cell in johns worksheet you wan the data
showing in yours.Every time you open your master sheet you will be asked if
you want to update the data or work with the data you alredy have
--
paul

remove nospam for email addy!



"Anthony" wrote:

Each employee has a workbook each with the same fields which they update, I
want to create a master workbook with all of the data from everyones sheets
which updates automatically when they make any changes? The fields will be
the same, im thinking this would be a complex lookup function??