Take a look at this post (among many others) on how to export to excel. Now you will need to add as many paste lines as different tables you have. You better use CopyValuesToClipboard from the second line on, you only need the headers once. Besides, you will need to do some tweaking to get the proper range where to paste the contents. If your tables have the same number of rows, this will be quite easy.
Hope that helps.