Compare two columns (from different sheets) delete if no match and insert if missing

Hi there,

Looking for some VBA help as I'm not an coding expert.

I have two tables in two different sheets (sheet 1 and sheet 2).
My requirement:
1. The data in Sheet 2 needs to be compared with data in Sheet 1, if there is match then keep that record.
2. If data matched but if it is duplicate as one of the above records then delete.
3. If there is no match found in Sheet 2 when compared with Sheet 1 then delete.
4. Insert if any records missing in Sheet 2 when compared with Sheet 1.
5. Arrange records in Alphabetical order - this is optional for me but other 4 are mandatory.

Can someone please help?

I'm attaching sample workbook with dummy data in it. Thanks in advance!!

Though I tried to understand the code but I couldn't able to but it is serving my purpose, so thanks a lot!
Closing this thread.