Hello, Helpers!

I am trying to compile a single master list of unique numerical records archived in hundreds of old workbooks.

I recorded a macro and got this code out of it:

Range("C4:C500").Select
    ActiveSheet.ListObjects.Add(xlSrcRange, Range("C4:C500"), , xlYes).Name = "List1"
    Range("C4:C500").AdvancedFilter Action:=xlFilterInPlace, Unique:=True
    Selection.Copy
    Windows("Book2").Activate
    ActiveSheet.Paste
Tweaks are needed. How do I make it paste the first archive's data in A1 to A?, the next archive's data starting in the next empty cell in Col A, and so forth, so I don't have to keep positioning the cursor?

Second, is it possible to have Excel go through a folder automatically repeating the above process until it runs out of files?

You guys have been a great help so far. I look forward to a solution.

Thanks!

Arlen