Locking data table to separate table

[Headline31]

In order to make formulas throughout my workbook to calculate properly, I had to split my main data entry tab into 2 separate tables; one "table" holding the names and the other "table" holding the data. The name table has the possibility of changing with new employees being added throughout the month. Is there a way to make the data in the second table move with the name it was entered with?