VBA：从多个工作簿/工作表中提取值

I need a macro to take the different values from column C of a workbook and compile the unique ones, either on the same sheet, new sheet or in a new workbook. I need a macro to take the different values fro