difficult to explain but here goes. I have a master workbook and have linked
(copypaste specialpaste link) cells from it to create several worksheets -
these worksheets have completely different formatting than the master.

My problem is that when i need to insert or delete a row from the master the
linked worksheets get jumbled - is there a way i can insert a new row into
the master without changing the locations of the linked cells in the other
worksheets?

Not really sure if it can be done but thoght i'd try.