remove a row from a table without affecting their referencing

[gleamng]

Good day all,
Please i need your collective help with this small excel database which i created. I have an excel workbook with lot of worksheets refrencing to one sheet in the workbook and also referenced to other workbook, but whenever i delete a record by deleting the whole row, it affects all referenced sheets and workbook from the row i delete downwards. My question now is how do i delete a row from the record without it affecting referenced sheets and workbooks???
Thank you all for your anticipated help/contributions.

 

[Fluff]

Dplicate https://www.mrexcel.com/forum/excel-questions/1048937-how-remove-record.html#post5039858

Please do not post the same question multiple times. Especially as you've had a response to your original post, to which you have not replied.
All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).