Combine Text Files from directory

Is there a way excel would be able to combine multiple text files, (comma delimited), into one spreadsheet when a macro is initiated?

For example I have 4-7 text files that we manually open and copy and paste into one excel document. Is there a way this can be automated?

Thanks.