Urgent! Need to gather data from multiple excel files without opening and populate in one file

[stretch90]

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!