I have several sheets already setup and ready to accept info entered from one
main sheet. Here's the problem I have. I assign cases to officers in my
building. I have created sheets for each of the officers. So that the
clients will go into the correct location. I enter the info on main sheet
where most of this information is going to be entered such as last name,
first name, case number, and so on. How do I get the information for each of
them to drop into the correct sheet that I want it to go to.