@josefina2215 If you are not familiar with PQ, perhaps this is a good start:
https://exceloffthegrid.com/power-query-introduction/
Though it may a bit overwhelming in the beginning.
In particular, chapter 9 deals with connecting to files in a folder. Perhaps it's something you can use. But you may need to clarify your intentions. Upload or share a file explaining what you want to do.
