I'm trying to get some data from the excel files in a folder, and I already know how to get some data from an external files.
How can I you get the data based on the file's name without typing it manually? Can I just reference the cell next to it as the file name?
Note that all of the town files have the same exact structure with different data.