Copy specific excel files from sub-folders to a target folder based on file namelist in excel

[kismatstha]

Hello everyone,

I have a folder on my desktop. It has multiple sub-folders and some excel files in it and each of the sub-folders contain atleast an excel file.

I want to move some specific excel files from some sub-folders to a target folder in a different location based on the file name list in excel. So I am looking for A VBA code or some other ways for that.

Kindly assist me in this.

Thanks in advance.