Thread: How to insert row without affecting linked cells

I am not very well versed in excel, so go easy with the jargon and if solution is something more complex than pretty much copy/paste pls explain for dummies.

OK, so I have a workbook to this description;

Sheet 1: Over 3,000 names with contact details

Column B Column C Column D Column E Column F Column G Column H
Title First name Surname Position Organisation Email Category

Sorted by
1 - Organisation
2 - Surname
3 - First name

Sheets 2 - 9: Are partial lists of Sheet 1 (respective of category) that are linked to Sheet 1.
Obviously sorted same as Sheet 1.

I WANT TO
Be able to insert a new row in Sheet 1, without it affecting Sheets 2 - 9, and then insert the new row into the appropriate Sheet (category) with a link back to Sheet 1.
Is there a way of doing this?

The main priority is to be able to edit info in cells in Sheet 1 with the info updating automatically in respective sheets - which has been done by linking using paste special.

I want to be able to insert a new row in case extra contacts are needing to be added, without having to copy and paste special each sheet again. At the moment that is the best solution I have and would prove time consuming to do every time I add a new contact.