Copy paste all sheets from file to another file from selective folder in VBA

[manoj_arsul]

Dear All,

can you please help me to create program in VBA . I tried many time but not getting exact result.

Condition :
eg. Threre is one folder or many folders in given path. ( Path has to put in Sheet1 A8)
we have to open all the excel file from that folder(path) and copy paste sheet from each file and paste it in our file.

C:\Desktop\Temp Folder
if There are 10 files in temp folder. & Our file working name is Combine.
so we have to open each file one by one from temp folder & copy sheets and paste that in Combine file.

Thanks & Regards,
Manoj Arsul