Updating of data between worksheets

Hi all,

I have 2 worksheets, Worksheet 1(ItemAllocation), Worksheet 2(ItemOrders).

Whenever a set of new data are added to ItemOrders, the data will be copied and updated to Itemallocation and separated based on their item No.

Example are in the attachment files.