Need help with VB Macro to compare 2 worksheets

Experts,

Attached is an excel document that contains 2 worksheets named "Structure_DATA" and "XML_DATA". The requirement is that I have to compare data in these 2 worksheets and report the differences in a new worksheet (of same workbook) named "Structure_XML_Comparison".

If you look at the Structure_DATA and XML_DATA worksheets, the columns are common ( 5 in number), but the data in the rows are not the same. Here, "Name" column is the primary key to compare. I need a macro to do the following:
1. If the data in the "Name" column of XML_DATA worksheet does not exist in the Structure_DATA worksheet, get that specific row(s) from XML_DATA and report it as "Added_Items" in the comparison sheet (on the XML_DATA - Right hand side). Refer to the format in the attached excel doc.
2. If the data in the "Name" column of Structure_DATA worksheet does not exist in the XML_DATA worksheet, get that specific row(s) from Structure_DATA and report it as "Removed_Items" in the comparison sheet (on the Structure_DATA- Left hand side).
3. If the data in all the columns of both the worksheets is exactly same, then report it as "Unchanged_Items". Show the matched rows on both Left and Right hand sides.
4. If the data is different in any of the columns of both the worksheets, then the specific value which is different needs to be highlighted in red on both sides. All the modified or updated rows, should be reported under "Modified_Items"

I am not comfortable with the Macros, so will need help from the experts to get the macro logic for the above. Appreciate your help in advance.