How do I pull data from several tables into one, where the table name follow a certain pattern:

EX_001
EX_002
EX_003
..
..
EX_N

Where new tables can be added continually in the same pattern - and this data also should be included in the SQL?