We have an Excel workbook with multiple pages to aggregate our credit card expenses. There is a summary sheet and a sheet for each user's credit card statement which are pulled from their individual Excel workbook. Each individual person's sheet has a list in cells C2:C26 of the jobs he/she worked on; not all lists will be the same length or contain the same jobs. I am looking to generate a single list of unique values on the summary sheet.
I am including and example of the type of worksheet. We would want to dynamically create the list in C2:C26 on the Summary sheet from the data on the other sheets' C2:C26. VBA macros or formula language are acceptable.