sort data from multiple sub folders

[jeffgriffin]

Hi
I have a code that open multiple sub folders and selects different information from any excel file.
The code is

Please Login or Register  to view this content.

The folder DATA has the sub folders DATA 1 DATA 2 DATA 3 MATERIALS, all have excel files,
How can i modify the code so it does not read the folder MATERIALS ?
I have tried \data\data_? and \data\data_*

[AlphaFrog]

Maybe something like this...

Please Login or Register  to view this content.