Ok, so I have been looking for a clean and clear solution to this all morning and can't find one. I would like to compare two lists on different worksheets (sheets 1 & 2, column C) and create a new list (Sheet 3, column A) that will update with worksheet changes to combine the two lists and not include duplicates.

Sheet 1
Column C
Apple
Oranges
Bananas

Sheet 2
Column C
Apple
Banana
Peach

Sheet 3
Column A
Apple
Banana
Orange
Peach

I would prefer a VBA solution that will not require any user input and happen in the background. This table will feed into PowerPivot (no duplicates, no blanks, etc.) Any help is appreciated.

Thanks