Consolidate Excel Data & Verify Emails

I have several customer lists scattered across different Excel workbooks. My priority is to merge every record into a single, reliable master sheet so I can finally trust the data. Accuracy comes first: I need duplicates identified and resolved, inconsistent name or address fields standardised, and any obvious entry errors corrected.

Once the data is clean, every email address must be verified online. Invalid or disposable addresses should be flagged or removed, and I would like a quick summary of how many contacts remain deliverable once you finish.

Deliverables
• A consolidated Excel file containing all unique, cleaned customer records
• A brief reconciliation log showing where duplicates were merged or conflicts resolved
• An email-verification report listing valid, invalid, and unverifiable addresses
• (Optional but appreciated) a repeatable macro, Power Query script, or short step-by-step note so I can rerun the process later

Feel free to lean on any combination of Excel formulas, Power Query, or VBA—whatever gets the job done accurately and efficiently. Data privacy is important, so all files must stay confidential and be deleted from your side once the project is complete. If you’ve tackled similar consolidation and email-verification tasks before, let me know your approach and estimated turnaround time.