Link different worksheets in different workbooks to 1 master workb
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??
|