I have a question regarding a macro that will search a drive for all excel files that start with a given character(s), open that file and pull data from a given tab, close it, and continue the search until all data has been successfully pulled and stored. Any help or suggestions would be great.

Thanks,