Consolidating data from certain sheets in a master summary sheet

Hi

I have a number of xlsx files that I need to compile in one master excel file, they are contained in a master folder and sub folders, all files begin with PJ anything other than this are to be ignored

I have included a few sample files and a master file which shows where the data is from.

I need to search the folders for the files and retrieve the data from the relevant xlsx files and compile them in one master file.

Master file From cell in PJ .xlsx file
Date ------------- E5 ----------------- To cell A1 in Master file
Name ------------ H5 ----------------- To cell A2 in Master file
Time ------------- E8 ----------------- To cell A3 in Master file
Age -------------- H8 ----------------- To cell A4 in Master file
Gender ----------- H11 ---------------- To cell A5 in Master file
Type ------------- E11 ---------------- To cell A6 in Master file
Address 1 -------- E14 ---------------- To cell A7 in Master file
Address 2 -------- E15 ---------------- To cell A8 in Master file
Address 3 -------- E16 ---------------- To cell A9 in Master file
Address ---------- E17 ---------------- To cell A10 in Master file

Will each PJ file contain only the one record? How many PJ files are there? Are there any other files in the subfolder or just the ones beginning with PJ?

Will each PJ file contain only the one record? Yes there will only be one record per PJ file

How many PJ files are there? At the moment there are approximately 130 PJ files, but this growing weekly (10 ish, added per week)

Are there any other files in the subfolder or just the ones beginning with PJ? there are only xlsx files in the folders, sub folders and all the other files begin with "Weekly" only the project files begin with PJ

I would also need it to not duplicate results if scanned twice, if possible

Hope this makes sense.

Hi RoyLittle0

Is there more than one Sub Folder that contains PJ Files?

Hi RoyLittle0

This Code is in the attached

Please Login or Register  to view this content.

You'll need to change this line

Please Login or Register  to view this content.

And this line

Please Login or Register  to view this content.