As user fills out data sheet, then fill out a results sheet based on data sheet entry

I have a data sheet that a user will continue to add records in the last empty row. Then they will place an "x" into (3) columns indicating what type of data it is.

I have a seperate sheet dedicated to each Column type. Depending upon where they place the X (in whichever Column), then it shows on that specified results page. How do I set up a feature that once a user enters in the data in the last row, it will automatically be added to that specified results sheet?

I have a sample workbook attached. Its pretty easy and self explanatory once you see it.