I have a macro that contains a drop down box with a list of file names that are contained in a single directory. Currently, I store the file names in a separate sheet and have to manually enter a new filename if a new file is added. Is there a way I can code something to pull the names of the files in the directory?