Combine columns from Excel files into one column

Combine columns from Excel files into one column

I have numerous files with "Visit Date" across all the files and I want to
combine all these "Visit Dates" into one sheet with minimal human
intervention. The files get updated as I type, and I need the Visit Date
sheet to be automatically updated. How can I achieve this?
E.g
File A: column A: Visit Date
File B: column A: Visit Date
File C: column A: all visit dates
I want to combine the visit dates from file A and B into C, is that
achievable?