An SQL query of the following form should do it (pseudo-SQL):
select the variable names from the dictionary tables
where names in list-of-table-names
group by variable names
having count(*) = number-of-tables;
Use a case-shift function if required.

I have not tested this but the concept is fairly straightforward.
A slight deficiency is that you must count the list-of-table-names yourself.