Build a dataflow from Onedrive folder

For combining files automatically, you need the files to be stored at the same folder. Otherwise you need more expertise at Power Query in order to filter from all files the ones you want, add a column to read the tables, and combine them. That would work if the columns match to combine.

Regards,