You can record that yourself.

1) Turn on the macro recorder
2) open first file
3) Use the Data > Filter > Advanced Filter to filter that column for UNIQUE VALUES
4) Copy all the visible cells and paste in your 3rd file
5) Close first file without saving any changes
6) Repeat 2-5 with second file
7) Turn off the macro recorder.