Link different worksheets in different workbooks to 1 master workb

A

Anthony

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??
 
P

paul

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
 
A

Anthony

The sheets have different data however the format of the data is the same and
the structure of each of the sheets is the same, i don't really see the point
you are making Paul - if one of the employees enters a new row of data i want
that to update the master sheet when it opens with your method i think new
links would need to be added each time new data is added. Thanks for the
initial help tho!!
 
Top