I have the need to regularly update an analysis "engine" worksheet with large abouts of data from multiple excel files.

These updated data files will all have unique names and will reside in the same folder (won't change), and they will be dropped into the folder several times per day.

I would like to be able to have a macro copy ranges from these closed files so that I do not have to embed the file names and folder locations into individual equations (with the associated problems this can cause. I would rather have raw data sitting in the cells at the end of the day.

Basically I am trying to copy data ranges from a closed Excel file into an open one on a regular basis without embedded formulae.

Any ideas? Thanks in advance.