Inserting row in 1 worksheet and updating a different row in another worksheet
 

I have 4 worksheets, 1 parent and 3 child forms that have links to data
on the parent worksheet. The rows on the child forms are not a one for
one to the parent rows. ex. data in row 1 of parent spans rows 1 - 10
in child sheet 1, spans rows 1-5 in child sheet 2 and spans rows 1-15
in child sheet 3. Row 2 of parent sheet spans rows 11-15 in child
sheet 2, spans rows 6-10 in child sheet 2 and spans rows 16-20 in child
sheet 3.

Now my client has asked that when they insert a row in the parent
sheet, say in between rows 1 and 2, that child sheet 1 will insert a
row between 10 and 11, insert a row in child sheet 2 between rows 5 and
6, and inserts a row in child sheet 3 between rows 15 and 16. All
while maintaining links to the parent sheet.

Thanks

James