I have created a master spdsheet and linked it to 3 other sheets. Here are the tab names
(Master)Diane, Wayne, Su
I enter new projects that each person is responsible for daily
How do i link the new projects that i enter and put the information under the correct tab. For example if I enter a new project and the person responsible ( FXT - Project and Dianne is responsible) how do link the new information that I entered to Dianne's tab and not the other two tabs

Also, if I decide to give the project to someone else how do i get the sheet to pull in the new information under the right tab. Example (IF I delegate the SCO project to Wayne instead of Diane