Merging several workbooks from folder to 1 workbook in different s
 

Hi All,
looking for a macro wherein I can extract details from 10 different
workbooks located in particular folder into a new workbook , details of each
should be on new sheets.

eg. there should be 10 sheets having all the details of 10 workbook located
in a particular folder.

Appreciated your help

Regards,
Chirag