Help keeping data intact even when adding rows across multiple sheets

Hi there,

Need help here.

Had a previous thread where WINON helped me solve most of my problems with a current workbook I have.

I have however stumbled upon another issue, which I cannot solve myself.

Find attached my excel worksheet (FYI: password is "EMDEN" if you need it)

As you can see There is a Master file called "BUYER +" and then a whole lot of other sheets. If data is entered into the sheets, it updates the BUYER + sheet accordingly. However, only until column 13. Column 14, 15, 16 & 17 only gets edited on the BUYER sheet, then updates those columns back to each respective sheet.

So you see, that ALL sheets and the BUYER sheet is working together and updating each other (though only certain columns to avoid confusion and looping problems).

The problem I am experiencing though is that the columns which I enter into in the BUYER sheet is static (the columns that should update the sheets). It does not adjust to stick with the rows that are inserted on the other sheets.

In other words. I can insert a row (A) into the first sheet with a reference, and then another row in sheet 2 (B). But if I put a new row into sheet 1 (C), it will shift the sheet 2 row (B) on the buyer sheet down once, and the data in the final columns, now stays put. Thus giving the info of Sheet 2's 1st row (B) to Sheet 1's second row (C).

I hope you can understand the issue. Examine the sheet as is first. Note the areas that are copied to each cell etc. Then insert a new row of data in sheet AM (from column A - M) and you will see that the last four columns of data entered for row 3 on the BUYER sheet, is now refering to the wrong row.