VBA Script for AutoFill based on criteria VLOOKUP()

[apamix]

Hello everybody,
This is how looks my table (for better view look here)

My goals here are :

When somebody enters a data in SKU column which is matching to already existing one the new data will go one roll below the old data and copy several details like Description, Unit, Cost, Inventory Value. In the perfect scenario, the Reorder Qty in the duplicated data will be 0 and the Reorder will be calculated based on total Qty from the SKU.

So far I was able to sort if the newly entered data in column b is matching to something already exist will go to one row below with this VBA script:

Private Sub Worksheet_Change(ByVal Target As Range)
    On Error Resume Next
    If Not Intersect(Target, Range("B:B")) Is Nothing Then
        Range("B5").Sort Key1:=Range("B6"), _
          Order1:=xlAscending, Header:=xlYes, _
          OrderCustom:=1, MatchCase:=False, _
          Orientation:=xlTopToBottom
    End If
End Sub

So I think the next is to get some AutoFill values ( Description, Unit, Cost, Inventory Value ) based on matching criteria ( SKU ), but so far I'm unable to build it Any help will be appreciated.