I am trying to do the following in excel 2010:

For instance:

If I have a directory file name "Brazilian Navy Ku" and then I have another directory file folder name " Brazilian Aeronautical VSAT Spares"; then it will go through the first directory file folder name, search for excel files, open the excel file, search for any worksheet tab with tab format XX.XXX or tab format XX.XXX.XX, then retrieve information from certain cells within that excel file.

I just need to be able to have it search within a folder by a certain name criteria of the folder name. I only need to search file folders that meet the criteria specified within the criteria box.