Hi,
I have a excel form that is filled out in hundreds of different files and I need to compile all of the data into one file. I created a macro that creates a new sheet and extracts all of the data from the form in a single row on the new sheet. It works great but would take too long to apply individually to hundreds of files.

Does any one have a code that allows me to select a folder and then have the macro I've already designed be applied to all of the files in the folder. Then once all of the files all have a single row of data, compile all of the rows of data onto one table.

Thanks in advance for the help.