Hi
Im hoping someone can point me in the right direction.

Im not sure what its call or how to do it but I need to separate a complete list of staff names, phone numbers, managers and contract hours from a main page to each staff to a tab for each manager in the same workbook. I need that when I add a name to the main page that it then put that name into the tab that is for that manager. For example then names below would be on the main page for quick look up but then they need to be on separate tab for each manager with the contact and contracted hours details so that we are then able to see who is managed by who at a quick glance.
eg
Community Care Worker Phone No Manager Contract Hours
Margaret Smith 0415 021 584 Karen 60
Jane Jhones 0412 658 598 Margret 30
Kim Lane 0148 785 458 Chris 45


Unfortunately I haven't used excel for anything beside basic data recording in a long time and was asked to see if i can work it out.

Thank you for your help in advance for being pointed in the right direction.