Can a script loop through every table in a base?

Can a script link a record in TABLE A to the matching records (via email addresses) in multiple tables TABLE B, TABLE C, TABLE D, etc in one go or does each one have to be its own scripting app?

Thanks!