Unique value party
 

I'm trying to figure out how many unique trailers were used for shipping over
the course of one year.

How would I make a separate spreadsheet to record a list of all the unique
values in the Column Cs of 30 different worksheets?

Thanks for your help!

Arlen