WBs to 1 Sheet code doesn't allow to choose certain data range from source workbooks

[Mahmoud.1st]

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

[PCI]

"also if i get to choose where to paste these data in the master sheet."
It means you want a message to ask you where to put the data...?
Can you send samples of the files to treat and give example of the values selection

[Mahmoud.1st]

Hi PCI, and thank you so much for you answer and concern.
i meant with the mentioned that if i could for example extract range C2 and paste it in Master sheet in A2.
i attached example of the file and the needed cells to be extracted are the following
C2, A5, C5, P5, C9, and R5
what i'd like to have is the data in the cells mentioend above from sheet 1 and in the row below same data from sheet 2 and so on.
the file sample is in the following link on Dropbox
https://www.dropbox.com/s/or4avg54zu..._No1.xlsm?dl=0
thank you so much,
Mahmoud

[PCI]

Try next code
There could be some issues with the file you sent because it making reference to some external values, and when loading it, it ask for an update.
But this can be remove later on, first check if it is OK
Note statement Const where is define the cells to copy

Please Login or Register  to view this content.

[Mahmoud.1st]

Thank you soooooooo much, selecting certain data range works fine now, only 1 thing i changed in your code which is that i changed back the part which allows me to chose the location of the folder rather than selecting the data from the active sheet.
now i could proceed with the project and the rest of the issues i still have is no show stopper, i will share it with you below if you have an opinion
- copying the data in the master sheet without the original sheet's formatting.
- if i could disable the question when it asks me to keep the old data, as i always need it by default.
- once i run the macro it keeps asking me to Update for before copying the data from each sheet, i will see if i could eliminate this as well and makes it run automatically.
once again thank you so much for your support, much appreciated
P.S: Reputation added

[Mahmoud.1st]

Thank you soooooooo much, selecting certain data range works fine now, only 1 thing i changed in your code which is that i changed back the part which allows me to chose the location of the folder rather than selecting the data from the active sheet.
now i could proceed with the project and the rest of the issues i still have is no show stopper, i will share it with you below if you have an opinion
- copying the data in the master sheet without the original sheet's formatting.
- if i could disable the question when it asks me to keep the old data, as i always need it by default.
- once i run the macro it keeps asking me to Update for before copying the data from each sheet, i will see if i could eliminate this as well and makes it run automatically.
once again thank you so much for your support, much appreciated
P.S: Reputation added

[PCI]

To avoid the update, you may use next code

Please Login or Register  to view this content.