My two files are volumous and we have done "re-link" between two workbooks
manually.
Basically, one workbook is a summary file (A) extracting total of each
worksheets from another detail workbook (B). User only need to update
workbook (B). Occasionally, workbook (A) needs to be updated if user
adds/deletes row in workbook (B).
