I am new to VB macros and wanted to write a code for copying values from multiple excel files to one excel file.

1. We have multiple excel file in windows explorer.
2. these excel files are in separate zip folders with certain naming convention. for ex. 3453
3. if we open folder (3453) then there some excels with different naming convention and i have to open a specific excel file with fix naming convention (stating with "Testing")
4. then i have to open the testing excel file and copy some values from different location and paste it to other excel with the same folder name cell 3453.

Can some please have a look and help me.

Thanks in advance.