Loop through folder of Excel Files and extract single column

[fioranosnake]

Hi,

I have a folder contain multiple folders. Each of these subfolders contains an excel file. Is it possible to loop through each subfolder and create a single CSV from the data from a particular column from each xls file. If possible can I ensure that only excel filenames starting with a certain text are read?

Many thanks for any advice.