Search Worksheet and show in table amount

[Tamster]

Can you search a workbook for a specific item in a row or column? I know I can use find and type in a name in the row or column, this will show duplicates in the workbooks. I don't want to have to search and type every single one if I don't have to. I want to be able to place them in another folder, so I can tell how many of a particular item is sold, during the course of the year.



Thanks for the help in advance!
Tamster