INSERT INTO Table1
   SELECT * FROM Table2
   UNION ALL
   SELECT * FROM Table3
   ... Add tables here