Automatically copy data from one table into another table

Hello Experts
I have an excel sheet with a table which I need to copy into a similar table on another sheet in the same workbook
It needs to be dynamic, so as data gets added/removed from table 1, this automatically updates in table 2

The reason I need to do this is,
I have linked the excel file to SAP B1 to draw the data from, but for some reason when I add this table to the Data Model in Excel I run into trouble and errors
For some reason, the SAP linked table doesn't like to be added to the Data Model

The easiest solution for me would make a copy of the data from table 1 into table 2 and since the table 2 isn't connected to SAP

I am hoping I won't be getting any errors

Please help I've attached a sample excel file

Thanks
Rahul

Hi Glen
Tried that, didn't work, I am just getting number in the columns?
Would there be something for pivot tables?
That grows with the table