|It's not exactly clear to me what your process is.|
Are you saying that you would be entering that info into the master list and as soon as "Bagwell" is entered, that row should be copied to the next available row on the "Bagwell" sheet?
If that is the case, then you would need a macro to accomplish that goal. The copying of a single line to a specific sheet based on the entry in a given column is fairly simple. Where things get complicated is when you make other changes to the master sheet, such as deleting data or make an error. "Whoops, I entered Filbert when I meant to enter Bagwell."
A task completed by a macro can not be undone with a simple Ctrl-Z. In fact, it can rarely be undone, period. Macros are really, really great at doing things but very, very poor at undoing them. The undo-ing in most cases needs to be a manual process done by the user. There is only so much that can be written into a macro to try and make the code idiot - errr - I mean - user proof. For example, if Bagwell is misspelled and a sheet with the misspelled name can't be found, that type of error can be caught and dealt with. However, if a sheet named Filbert exists, then the data is going to be copied to that sheet whether it belongs there or not. Once the user changes Filbert to Bagwell, the data will then be copied to the Bagwell sheet but it won't be deleted from the Filbert sheet.
This might be a case where a real database program would make sense. I have not developed any databases on my own, but it is my understanding that database applications, such as Access, can "re-associate" data much better than an Excel macro can. There would be a field for a "name" and all associated fields for that record would be associated with whatever name appears in that field. If you change the name in the name field, all of the other fields would follow the change. Reports would be pulled based on the name field and all of the data associated with that name would come along with it. In addition, reports could be built based on other fields, pulling matching data from multiple "name" records.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.