Copying unique data that ends with a specific character

[Closed]
Report
-
Hello,

I want to create a workbook that has a main input worksheet, then automatically copy new data that ends with a specific character to a specific sheet.

Like, if a data ends with, for example, number 1, copy it to another sheet, for example, named "Ends with 1". If the data already exists on the sheet, don't copy it.

Need help guys. Thanks.