VBA code to update master file and reflect changes on other workbooks

[Kimston]

Hi everyone,
I am trying to figure out the best way to accomplish a task of updating several workbooks from a master file. I have a master file which other users need certain particular information from this file. I like to know if there is a macro that can run on either on the master file or on the other files, and if there is a change in the master file, this change should be reflected on the rest of the other workbooks. For example in the master file, if an employee is terminated and identified as term in Column B, then the entire row for that particular employee should be move to the Terms Sheet. Also, if an employee change department, this change should be reflected on the rest of the other files. Can this be accomplished using a VBA code or pivot tables?
Your help is well appreciated.