Adding rows when cells are cloned/mirrored?

Hi,
I'm new here and newish to Excel (I'm using 2003) so I hope I'm doing this right and explaining what I need eloquently enough.

I have a workbook with two sheets in which I have cloned (mirrored?) cells. So in Sheet 2 (Terminliste) I wanted to copy what I have in columns A:D and G, H in Sheet 1 (Pipeline) - I did this with:

Please Login or Register  to view this content.

So far so good.

The problem is that for column J of Sheet 1 I want to populate that with the number that appears in column AH of Sheet 2 unless this is empty then it should contain column V of Sheet 2. I did this with:

Please Login or Register  to view this content.

This works just fine too. But when I try to add a row to Sheet 1 the information from columns E, F, and I to AI on Sheet 2 doesn't move down a row. The dates and page numbers in Sheet 2 appear to move up a row and the author details move down. On Sheet 1, column J is still fine but the code refers to the same cell as it did before.

I tried to solve this by repopulating cells in Sheet 1 with data from Sheet 2 (E, F, and I to AI on Sheet 2 appear as X to AZ on Sheet 1) and then relating column J of Sheet 1 to AY and AM on Sheet 1 rather than AH and V on Sheet 2, but then I just get blanks.

Because I'm using an IF formula I have to specify a row number, but I'm wondering if there is another solution (a helper cell, VBA, or similar).

When I had everything in the same worksheet everything worked fine, but I have some demanding colleagues who want the data on separate sheets as they want a better overview!!

Any help and suggestions would be most appreciated!!

karen