I have five excel workbooks and each of them has one worksheet with a table in it.

I want to transfer the tables from the worksheets of the other four workbooks onto the worksheet of the first workbook, say, with the tables separate by one row from each other after the transfer.

How can I do that without having to open all these five workbooks and doing copy and paste multiple times? Any idea would be much appreciated.