Hi, I have many files and one directory and they are all the same except the data in them. I am wondering if I am able to use power query or something similar that would allow me to combine certain data in these files and chart it. The data is all in the same sheet but the file has many sheets.
I have never used power query.
Grateful for your help.