Combine tables with same headers but different information

[theblackrazor]

I have 3 tables from excel linked to my access file.
All tables have the same headers, but different information stored
I would like to combine the said tables in one general table, but can't find a good way how to.
Please advise. Thanks
Can't attach the db due to some website filetype restrictions? (hope i described it vividly enough)

[theblackrazor]

Also please let me know if i can operate with more than 3 tables for sources( say 50 )((not kidding)) and what i would need to run this baby smoothly. (if its at all possible)