Hello Guys,
After sometime searching for a code to use in order to extract data from multiple excel workbooks in 1 folder in to 1 master sheet. i found the code written by Jerry Beaucaire. in the following link. https://sites.google.com/a/madrocket...s-to-one-sheet
to be honest it is very fulfilling and has everything exactly i need except for it doesn't allow me to choose certain range to be copied in the master sheet, rather than that it copies all the sheets in the mining folder.
what i need is, if this code with the same functions can be adjusted a little so that it allows me to choose certain values from the source workbooks, also if i get to choose where to paste these data in the master sheet.
following are few facts about my project
1- the source workbooks are identical in structure, just has different data.
2- values that needs extractions in the master sheet almost 5 values.
3- number of total source workbooks can reach 10,000 workbook, and the question is that can this code handle such amount of workbooks?

Thank you so much in advance for your support.

regards,
Mahmoud