How to match, merge and sum data

[owum]

Hi all,

Calling for someone who can help me here with VBA macro.

I have data A1:D13 in Sheet1 where I want to match the data in Column A2:A13, then copy and sum the rest of the column to Sheet2 if they are matched, along with those which are not matched. Note that in column B, I want to 'merge' the string if data A is matched. Finally a status '1' or '0' if it has been changed. Please see the attached sample file.

All help is much appreciated! Thank you very much!