Hey,

I'm not entirely sure this is possibly, but I would like to build a file that has a macro that examines files within a pre-determined folder and searchs for a specific tab within each file and compiles data from the same range from each file.

For example) Say I have 20 files in folder "C:\Users\username\Documents", some of the files contain the tab "MASTER", some do not. Is there any way to say, where tab "MASTER" exists in a file within folder "C:\Users\username\Documents", return all data from A9:J20000.

Example of sample file attached.

Any help would be appreciated.

Thanks!Test.xlsx