Hi
Open a workbook where you want to collect tables (target);
Open one of workbooks with table to export (source);
Right-click on tab where the table is located, and select from drop-down
menu 'Move or Copy ...";
In 'To book' field, select the target workbook;
Optionally you can check 'Create a copy' (to peserve table in source
workbook too, otherwise the sheet will be moved). And you can determine the
location, to where the sheet will be inserted in target workbook;
Press OK;
Close this source workbook (optionally saving it), and open the next one;
Repeat the cycle until all tables are copied/moved;
When copied sheets had same names in all source workbooks, then you have to
rename new sheets in target workbook.