VBA union all tables in database (1 Viewer)

Hi there,

I have a list of tables like this:

January_2014
February_2014
March_2014
...

Is there away I can create union within VBA that will search for tables like the above and add them to a union query or append them to a master table?

Users will be importing a new table each month so I need the VBA to pick new month tables

Kindest regards
Max

Are the fields always the same in all the tables ?
Are there forms build to see data from any table ?
I can't believe that with a list like that you spend every month hours to change all the links of forms to the new table...

Why not just import the data in the same table and add a field "Id_Year" where you store "January_2014" then just filter on the most recent one every month...

I agree with Grumm -- why not design a table and import.
Union queries are not updateable, if that is a concern.