I have thousands of records of search terms I have extracted from our web
sites. I am trying to combine all the duplicates and give a count after each
search term. Here's an example of the terms:

Search Terms
1 inch heel casual
2 inch brown pumps
2 inch brown pumps
2 inch brown pumps
2 inch brown pumps
2 inch brown pumps
2 inch brown pumps
2 inch brown pumps
2 inch heel

So I have used a pivot table that helps me do just that, except I have to
run a pivot table for each worksheet. I can't figure out how to combine all
the common search terms from all the worksheets and give me back one count
per term. I am using Excel 2003 and the file I have has 103,000 records.

Any ideas would be great,
Beth