I have a master document that is linked to 7 other excel
sheets. Now the other excel sheets are modified by
different users and the master document is for generating
reports.

But I found out that whenever new records are added in the
attached excel sheets, I lose some data from the Master
sheet.

Please any help would be highly appreciated.