How to compare 2 sheets data on a single sheet through VBA Codes?

I have 2 sheets in a file.One sheet is Current and other sheet is previous.Most of the part Code are same in both the sheets.But Qty,Rate and amount may be differ of a part code.Because,we are comparing to Current sheet from previous month.
Now,I want a summary sheet which shows the result as below:-

1-Place automatic all the part codes,part name and unit,having in both sheets in a single sheet i.e.summary or not repeat. ( Column B to D )
2-Sum up automatic total Qty and amount as per Sheet of a part code ( Column E and G for Current and Column H and J for Previous ).Rate is divide to amount by Qty.
3-Desired Result ( Column L to N ).Preferably descending order of the amount ( Column N ).

Can it be possible from VBA Codes or MACRO Working?

Please refer the attach file for more clarification.