Thread: Need to copy range from multiple closed excel files

I have a directory with many excel files and I need to take one line from the 3rd sheet from each of these and have it populate into another excel file. I need to write a macro to run through all of the files in this directory but I want it to gather the information while the files are closed. Please provide any help that you can, thanks!

I really need this! if anybody has any suggestions it would really help.