Copying Rows with Certain Criteria Met From and To Multiple Sheets

Here is the situation. Each time a part is completed, a worker copies and pastes the row for the part that has been completed into a particular excel file into two separate sheets. In the attached file the "Settings" and "Measurements" sheets are examples of the data that has been entered in.

I would like to find an equation I can use to look-up one of two possible values in Column D of "Settings" sheet, copy the row, and put it on a new sheet as seen in "Desired Outcome 1" and be able to do the same for the other value on a separate sheet ("Desired Outcome 2").

Secondarily I would like to know if there's a way to append the matching "Measurements" row to the sorted data.

I'm not that great at excel yet so I'm not too keen on running a Macro for it. All help and suggestions are appreciated!

Will the data on a particular row of the settings sheet always correspond to the same row on the Measurements sheet?

Pete

Yes, or I should be able to make it that way without a problem.

See attached file, in which I have added two new sheets - Outcome_1 and Outcome_2, purely formula-driven. I've also used two helper columns in the first sheet.

Hope this helps.

Pete

Fantastic! Thank you @Pete_UK just what I was looking for.