Synching some columns in multiple worksheets and align others

[excelmag]

In workbook 1, columns A-D have employee info (first name, last name, division, and supervisor) and columns E-H have dates trainings were completed
In workbook 2, columns A-D have the same employee info but columns E-K are tracking employee schedules and attendance
In workbook 3, columns A-D have that same employee info again, but columns E-I are tracking employee outcomes
(Each workbook is tracking additional info on other tabs, hence not having the previously mentioned sheets all in the same workbook)
I need a way to sync columns A-D between all three workbooks so that when I add an employee or change an employee's supervisor in workbook 1, it will show up in the other workbooks. I can't just use a reference formula because if I add an employee on on line 6 of workbook 1, workbook 2 won't move the employee schedules to leave a blank line for the new employee, so everyone after the new employee will have the wrong schedule.
I've also tried Get & Transform with the same problem.
Does anyone have any ideas??

 

[Special-K99]

Don't employees have employee numbers?
If you linked using employee numbers you could use lookups wince employee numbers would be unique.
I wouldnt personally lookup using first name, last name in case (unlikely as it is, but it has happened to me once) two people at the company have the same first & last name. John Smith for example.

 

[excelmag]

They do, but unfortunately, they come from our corporate office who changes each employee's number every year