|Before we could offer any assitance, we would need to know more about your workbook. You said that you have "the data categorized on individual tabs".|
Then you said you want to "to add a name to a master roster that would populate all the tabs" .
Copying data from the Master Roster upon entry is doable, as is sorting each individual sheet, but we would need to know exactly what you want copied and to where. I doubt it's as simple copying the entire line since that would mean that all of your sheets would look the same.
So you need to tell us what gets copied to each sheet and where it gets copied too.
You also need to tell us how you want the macro triggered. Do you want click a button after the data is entered, do you want it to happen automatically as soon as a certain column or row is changed, etc.?
Posting Tip: Before posting Data or VBA Code, read this How-To.