This has nothing to do with "two Apple tablets and a phone."
Probably you have same the same Phone number stored as different names or nicknames. You may have multiple contacts under a different email account.
Contacts are neither stored locally on an iPhone nor in SIM. They are synced to an email account that you had Google, iCloud, AOL, Exchange, Outlook, Yahoo or any Other
If Contacts on iCloud, try this --> Restore contacts, calendars, bookmarks and more using ...
- How many Contacts account (email client server) you have?
- What is your default Contacts Account?
- Which email account you are using to store Contacts?
- See the GIF below for Contacts and Default Account
- Learn how to add an email account and make it default (Watch the GIF)
- This example is for Gmail but the process remains same for all Google, iCloud, AOL, Exchange, Outlook, Yahoo or any Other