Using a macro, I'm wanting to take a folder that has several sub-folders and have the sub-folder names go in the top row of each column in a spreadsheet and the files within each folder entered below each corresponding folder, preferably while being able to specify file types. I found a macro for pasting the contents of one folder at a time, but it doesn't enter the folder name, it doesn't loop and it places the file name starting on the active cell. I just want A1 to have the name of subfolder 1, B1 to have subfolder 2, and so on. It would also be nice if it added a new sheet each time the macro was ran. Can anyone help me with this?