combining IF in OFFSET function-Need Assistance

hi everyone,

please have a look at the workbook i attached with this post.

okay.. i am trying to make price list data workbook.. this data workbook will consist of companies that i have separated into individual worksheets.

1) here is the situation.. i have created the Full List Sheets that containing the whole data.
2) In the company worksheets, i used OFFSET to the cells so that it will copy the data as the same in full list sheet.
2) but however for the Price Column in company sheets have a bit problem there.. each company has a different price to some the item. therefore i used IF() to determined in using the price in the column H onward.
3) but whenever i try to add a new row in the price list sheet, each company worksheet wont add the row and the price stuck there..

i need someone to help me combine the OFFSET() and the IF().

thank you in advance.. :-)