Copying Rows to New Sheet but not moving existing data

I have a master sheet that I want to sort into three different sheets. I want to set up an automation that copies a row given the project name, but I also want the automation to make sure that the row it is copying does not exist already in the target sheet. Does anyone know how to reinforce this validation?

Answers