I don’t know a solution as you’re describing it. But if your tables were setup like the below example, you could more easily search emails and the records they’re affiliated with.
List A
Email (linked record)
List B
Email (linked record)
List C
Email (linked record)
Emails
Email (email, first column)
The Emails table will have 3 additional fields, one for each table it’s linked to.