Consolidate Contacts Across Google Sheets

There are currently several Google Sheets in my Drive holding the same kind of information—people’s full names, phone numbers, and email addresses—but the rows are scattered across different files and sometimes repeated. I need everything combined into one clean master Sheet.

Here is what I want done:
• Pull every row from all the existing Sheets.
• Identify duplicate people and merge their details so each person is represented once, preserving every unique phone number or email that might appear across files.
• Standardise the columns (Full Name | Phone Number | Email Address), fix obvious typos in headings, and apply consistent formatting for numbers and addresses.
• Deliver one Google Sheet, neatly sorted (alphabetically by last name is fine), ready for immediate use and easy future maintenance.

Feel free to use formulas, Google Apps Script, Add-ons, or a short Python script with the Google Sheets API—whatever is fastest and safest for the data. I’ll share view-only links first, then grant edit access once we agree on the approach. A quick screen-share walk-through of the final result will serve as the hand-off and acceptance check.