Advanced Filter has both CopyToDifferentLocation and UniqueOnly options.

The ListRange, CriteriaRange and CopyTo ranges can all be on different sheets, but (from the keyboard) the CopyTo sheet should be active when the AdvancedFilter button is pushed.