Copy Data from Master Sheet to Subsheet Automatically

My boss has asked me to create an Excel file for him to keep track of employee assignments.
He wants a Master sheet, and then a subsheet for each employee.
Then he wants data that is entered to the master to auto-populate to the employee's subsheet.

So what I want it to do is to copy the data entered on the master sheet to the appropriate subsheet based on the value (the Employee's name) in Column A. If possible I'd like to to do this automatically without having to tell it to start or stop the macro....

Here's what I've got so far and now I'm stumped because I don't know anything about Macros. (And I would prefer a Macro over a formula because I don't want to have to do this all over again every time we get a new employee.)

Please help!
Assignments Master List.xlsm

I am not sure by what you mean automatically without having to tell it to start or stop the macro
even your code would not do it. You have to go to spreadhseet and run it, either through a button, or by pressing F5. Even if you were to do it using events, you still have to go data to trigger the code. I can help with a code if you
1. can run it by pressing a button
2. you need to have some data on the master as it is now is blank. Need to test the code

Based on Anka's master sheet, here is a macro if you want to use it.

Please Login or Register  to view this content.