summarize info in closed workbooks

I have a folder with multiple subfolders all containing an excel spreadsheet that is from the same template. I would like to extract the name of every file, and a couple of pieces of data from each spreadsheet (they have a naming protocol so part of the names are the same in every one). Can i do this if I all files are named '***123.xlsx' where the asterisks change? The information I want is in the same cell in every file. What about when I get a new folder and new file?

Hi,

Does that mean '****123.xlsx" is fixed and asterik value keeps on changing

you can use

If InStr(1, Filename, "123.xlsx") > 0 Then
further code

I was also working day before yesterday on the same task... use recursive function to check all folders and sub folders. Thanks