Link Workbooks - Auto Update
 

I have multiple workbooks (source workbook with multiple sheets) in which
dates, addresses and text are input. (I am essentially using Excel as a
database.) I want to link each of these workbooks to one master workbook
that updates the "status" of an activity when a new "entry" is logged into
one of the source workbooks. i.e. If I have new activity and open my source
workbook to "Diary," insert a new row, and in Column A enter the date, and
Column D enter the results of that activity, when I open the master workbook,
I want the corresponding cells in the master workbook to reflect the entries
I typed in the new row. Any assistance is greatly appreciated!
--
Kathryn