I am not sure what you are trying to do here. Are all the tables the same (same column names, count and data type) or are you creating one large flat table?
I would create your final table first, then do a series of append queries to move the data in. If you have any relationshisp to maintain, then you may need to use code to do this.
More info? Can you post starting table columns and ending table columns, etc.?
Look it up at: http://wrox.books24x7.com