Macro to take same named sheet for several workbooks in one folder

[almouchie]

Hello ,
I sould like some help, i tried to seatch to find similar posts but didnt find

I want a Macro to take a sheet (same named sheet) from several workbooks in one folder into a new workbook and paste each in one sheet in this new workbook.
i want to rename the sheets in the new workbook based on the value in cell D2 ( i can manage that

How can i manage that by simple opening the folder or do i need to open all those workbook manually for that to be done.

Apreciate any help to start with
Thanks

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/showth...med-sheet-for-several-workbooks-in-one-folder

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).