Formula to move a row to another sheet

[71-800B]

Hey everyone, so I have been using excel for a number of years and thought i was pretty proficient in it. started digging a little and realized I do not know as much as I thought. So i have spent the last couple days reading and trying to figure out how to make my sheet work.

basically I have 3 people working for me, bob, jim and sally. each of there names are in column A with each of there clients posted in the row next to there names in sequential order by the date. What I want to do is have all of Bobs rows automatically populate into sheet 2, jims into sheet 3 and sallys into sheet 4.

basically trying to break down each persons work load over the course of the month. I want to keep the office main sheet unchanged though in order of Appointments and Interviews as they happen though. just want the information transfered to the corresponding sheets. I think I will have to do this with macros but I really dont understand how they work at all, have been playing with them for a couple days and get nothing but errors. hoping there is an easy way to make this work and i appreciate all the help, cant believe this program can do as much as it can.

[icestationzbra]

hi there,

see Bob's tab and if addresses your requirement, extend the same logic to the other tabs.

1199