That Worked thank you! Also, I may eventually track several sheets, is it possible to loop this code for as many sheets I have and just change the sheet name/columns etc within each loop?

So for example if I have sheets 1-3 with my data I want to run this code one time and within the code if will look in each sheet and populate sheet 4 with a column of data that has no duplicates.

Thanks for the help I will definitely leave a positive rep.