I have 12 worksheets ( one for each month ) i have a list of names in the column "K" in all the 12 sheets. I have a separate sheet apart from the 12 sheets in the same workbook named as "Names" in which i want all the names from "K" column of all the sheets to be combined and i want the duplicates also to be removed .