Three of the tables in connection

Hello everyone. I need your help. I work with large documents. my work product separating between different divisions ( wee have three divisions). For one divisions i have one sheets with table. three tables with the same columns. I need that all information from three tables the information is copied into the fourth table in another workbook. The fourth table is used for operation pivot table reports. I need a macro that if you press the button resume the fourth table based on the three above. (in forth table i don't need empty space) and resume created PIVOT TABLE.

Table 1-2-3.XLS
Table 4.xlsx

maybe someone will help solve this puzzle

in one sentence would be so. How do I merge three tables in Excel that have identical columns?