Kopier tabeller over i en tabel

Det må være noget i retning af:

INSERT INTO tabelalle (uge,felt1,felt2) SELECT 1,felt1,felt2 FROM tabeluge1
INSERT INTO tabelalle (uge,felt1,felt2) SELECT 2,felt1,felt2 FROM tabeluge2
INSERT INTO tabelalle (uge,felt1,felt2) SELECT 3,felt1,felt2 FROM tabeluge3
INSERT INTO tabelalle (uge,felt1,felt2) SELECT 4,felt1,felt2 FROM tabeluge4
INSERT INTO tabelalle (uge,felt1,felt2) SELECT 5,felt1,felt2 FROM tabeluge5

Hvis jeg har misforstået problem-stillingen, så forklar lidt mere.

Dette virker for én tabel til en anden 100% kopi

INSERT INTO Final_tabel
SELECT * FROM Tab1

osv osv
INSERT INTO Final_tabel
SELECT * FROM Tab1

INSERT INTO Final_tabel
SELECT * FROM Tab2

INSERT INTO Final_tabel
SELECT * FROM Tab3