One Query - Multi Tables

[xlStar]

Is there a way to have one query to work on many table with same column names where the table name only differ by number?

For example...Table Name..

Table1
Table2
Table3

all have column column names, so on the query can I add a parameter to the Table name like

FROM Table[MyNo]

I just wanted one query and use the Macro to control using 1, 2 or 3?

 

[PWise]

Select *, 1 As Tablenum from Table1
union
Select *, 2 As Tablenum from Table2
union
Select *, 3 As Tablenum from Table3
where Tablenum = [please enter Tablenum ]