Trying to make a drop down list in excel that searches a folder of preexisting excel files, and when the file is chosen from that drop down list, the next columns over a filled with the preexisting data found in the excel file that was chosen from the first drop list. Not sure if this is something that can actually be done, but if it is possible, this would help exceptionally.
Solved by F. H. in 29 mins