Merge multiple tables

Hi there,

I want to merge twelve monthly credit card statements/CSV files into one file/table - in a dynamic way, so if source files change, the combined table changes.

Conditions:
1. The source data has no unique identifier per row. The date, for example, can appear many times, similar to the amount, payee, etc.
2. I do not want to touch the original CSV files; therefore do not want to open each file before I combine them. Adding unique custom keys would not sound like an attractive solution.
3. All "solutions" I have found use data management tools like power query, but I do not want to sum up results or combine a new entry from info from multiple tables.
4. I know that each row has one independent data entry, so no sophistication is needed; just add one table after the other and sort by whatever.

Is there an easy way to achieve this?

Thanks to the community!