ID unique text and copy to another sheet within workbook

[Dave Lortz]

I'm looking for a formula that will search the workbook each time text is
entered into a certain range of cells, and if it is unique (or first
occurence) it will place the text in a sheet for use in totals.