running a query on a list of tables

I am trying to figure out how to run a query on a list of tables or views
in this case.
I can run :

I can run :

SELECT * FROM tablelist;

which returns a list of tables

names
----------------
mortgage
creditcard
auto
........continued

I want to run :

SELECT * FROM (SELECT * FROM tablelist);

all tables have the same columns and types.

any idea how to make this work? tablelist contains a large number of tables
that will change over time and I do not want to manually write a bunch of
unions.

any suggestions?

Thank you