Export multiple tables among servers
what you are looking for is to dynamically create tables in the destination.
or in other words Copying tables from Source to destination programmatically

here is a very useful article that transfers tables from access to sql dynamically
but you can take the same concept and apply it on your source as well.

https://stackoverflow.com/questions/6298806/how-do-i-programmatically-get-the-list-of-ms-access-tables-within-an-ssis-packag