How to Copy cell value of all files which inside of folder and append to Master file

Dear all

I have 3000 files in folder called c:\mdetails with different filename but same format. I want to create seperate Master file called Completelist.xlsx by copying some cell of each file and append it to completelist.xlsx

Cell Nos of files--------------W8 ------------> A2--------Cell no of Completelist.xlsx
in the folder mdetails-------F6 ------------> B2--------
to be copied to--------------F8 ------------> C2 --------
Completelist.xlsx ----------- F10 -----------> D2
------------------------------- F12 -----------> E2
------------------------------- F21 -----------> K2
------------------------------- F23 -----------> L2

Sample of files attached.

Please provide the help.

Best Regards,

hi snsuvarna, please check attachment, press Run button

Hi, I am interesting in what you have done to create the code for this as I would like to do something like this myself, can you briefly explain how you have created the code to select the individual cells.

Also is it possible to manipulate the file structure that it only looks for files that begin with "PJ ?????????????? .xlsx" as I have many files in many folders, also would it look in sub folders.

Thanks for any help

@RoyLittle0
1. To select files under the specified mask: "PJ ?????????????? .xlsx" this line should be changed to include wildcard file name to look for:

Please Login or Register  to view this content.

2. The code gets the folder to inspect, opens every file under the specified pattern, takes non-empty cells as per template to an array and outputs final result on the sheet
3. It would not look in subfolders