Is it possible to dynamically name an Excel Table?

Scenario:

I have 100 excel tables in a worksheet. Those tables have employee data - empID, empName etc. Then, I am consolidating all the tables in a consolidated table in masterEmp table using VBA.


If I have to name each excel table manually, it will take me a lot of time. If there was a way to name an excel table linking it to a field in the table ex. empID, then my tables will be named as per empID which is an ideal scenario.

Please help?