Copy specific sheets of multiple closed workbooks to new workbook

Is there any chance for helping me in this topic please?
Happy vacation, everyone

3 Seconds im my PC!
Need for all 12 month? Simply change For i = 8 To 9 to For i = 1 To 12

Please Login or Register  to view this content.

3 Seconds im my PC!
Need for all 12 month? Simply change For i = 8 To 9 to For i = 1 To 12

Please Login or Register  to view this content.

Originally Posted by JACK JOUSH

I have containing Many of the closed workbooks each have several worksheets, I only need to create new workbook which names contains the sheets August & September, ...

Try

Please Login or Register  to view this content.

That's wonderful .. I am so grateful for you Mr. jindon You are wonderful and I liked your approach in coding
I will come back to you later, Regards

In fact Mr jindon It is greater than I imagined and is a wonderful surprise for me.
I have one extra point to complete this wonderful treasure The point is I need to sort the names alphabetically depending on the column F
In both of the two sheets ( August & September ). Hope this makes sense. Regards

@jindon

Well, in fact my code work for month 8 and 9.
Can be modified for 12 month only modifying For...Next 8 to 9 into 1 to 12.
Certainly OP spoke of only two months but his master Workbook, like the five operating Workbooks,
contain 12 Sheets, then I imagined more then he said.

The OP also claimed three times your code is ok but he needed much faster one.
Well my code keeps 3 seconds in my PC (i8, 3rd generation), how much time your code in your PC?

What about the code length and its simplicity?

You have been the one that solved my first problem (a very hard problem for me) on my first
appearance on this forum and I reputed you with "SOLVED by a Giant"... my fault!

JACK JOUSH,
Try add lines in bold.

Please Login or Register  to view this content.

BTW
To all the viewers in this thread.

I saw a pointless post #12.

I've just responded to the OP's request in post #6 saying

Originally Posted by JACK JOUSH

Any help would be greatly appreciated!!! - thanks in advance...

1) The option for choosing the one from the posted codes is only goes to the OP, no one else.
It is only the OP knows his/her real situation.

2) The length/simplicity of the code doesn't reflect "better", "faster" at all.
The point is what/How it does, like my code is checking the existence of the "August" and "September" sheet in each workbook before processing further, otherwise it will fail completely.

3) My code took around 1.5 sec after the selection of the folder for 5 workbooks on my little old PC.

Mr jindon, My tongue is unable to say thank you because saying thank you is not enough at all.
I've tested the code on a lot of closed workbooks ( 120 workbook ) . it takes nearly 15 second and that's really perfect and amazing.
Thank you for an elegant, efficient solution .... With my best wishes of good and great luck for you forever

You are welcome and glad you like it.
Thanks for the warm words and rep.