MI-L combine tables

[Simmonds, Ashley (OPT)]

having a blonde moment and need a quick answer as to whether it's easy.
 
can i easily merge a gazillion small tables into a single table without
coding up a massive function?
 
just wondering if there's a simple solution rather than writing something
like....
 
for each file in such and such
    open file
    select all (1 object) from table
    copy
    paste into merged table
    close file
next file
 
bus routes if you must know.