I got some very useful info from here and was able to use some code to copy a
row from a source worksheet to a tracking worksheet by "BeforeDoubleClick" in
visual basic. I need the "tracking" worksheet to stay updated each time the
source documents are changed. I know how to link and double click to add
additional rows but how do I set it up to do both - update existing rows in
the tracking sheet when info is added, changed or deleted in a source
document where the row already exists in the tracking document AND add the
new rows to the tracking sheet when they are added on source documents with
continuing updates as already stated?

Basically what I have is a loan manager and 3 loan officers. The loan
officers have a worksheet called a "Pipeline" where they list all pending
loan information. I need the information from each "Pipeline" to be listed
on the "tracking" or summary sheet for the loan manager to review. He
doesn't want to look at each individual "Pipeline" report. Additionally he
wants to be able to sort the "tracking" or summary sheet. I also need to
know if sorting the data on the "tracking" sheet will affect the continuing
updates and addition of new rows.

I appreciate all the help I can get.