Excel Data Comparison with Visuals

I have two Excel workbooks that hold similar datasets. I need a clean, automated comparison of every record using the unique ID/code column as the key. The goal is to see, side-by-side, what exists in one file but not the other, flag any rows that appear more than once, and then wrap everything up in a concise visual summary.

Here is the exact scope I have in mind:

• Read both workbooks, match rows solely on the unique ID/code.
• Generate three clear tables:
 1. Items present in File A but missing in File B.
 2. Items present in File B but missing in File A.
 3. Items that occur more than once in either file (show counts).
• Create a summary sheet that lists total counts for each of the above and embeds an easy-to-read chart (bar or pie is fine) so the results can be grasped at a glance.
• Keep the solution native to Excel—Power Query, formulas, or VBA are all acceptable so long as the file remains portable and the refresh process is straightforward. No external add-ins please.

Deliver the finished workbook with all comparison logic in place plus a brief note explaining how to refresh or extend the checks if new rows are added later.