Automatically update SHEET2 when SHEET1 changed

Hello everyone. Its me again with new excel problem ...

So I have this excel to record magazine delivery. Sheet1 contains all magazine details and sheet2 contain receiving records.

Sheet2 contains same data from sheet1 for column A, B and C

What I want:

Sheet2 will automatically add new row when I add new row to sheet1

Sheet2 column A, B and C will automatically updated with changed data(if any) from sheet1

Attached EXCEL.
http://www.excelforum.com/attachment...1&d=1468393760

UPDATE

I have this code which will add new row at sheet2 using macro BUT this code not suitable for merged row which I have.

(If Cells(N, 1).Value = 0 Then)

Please Login or Register  to view this content.

anyway to solve this?