I want to copy a named range (which is essentially a summary table) from several files, which are located in different folders, into one master file.

The files with the data are all located in one paste (named Case1) and so I'd like to be able to access all the excel files located in that folder and copy that named range into the master file. I don't want to specify the names of the excel files which contain the data.

Is this possible?