Dynamically autopopulate a table

Hello excel family,

I have a challenge i need resolved, i an trying to come up with an excel sheet where when a user posts data on the first tab named data sheet, it should automatically or dynamically update in the second tab named dynamic table. Reason being is the data is being downloaded from a database which i want to be pasted directly into this excel sheet without being altered. The data being pasted will not be of equal rows(it might have between 1 to 5000 rows) and the key information is in the A column of the data sheet.
in the dynamic table sheet, i want it to auto populate whether there are 3 rows or there are 3000 rows.