I am new here and need help

[sjaveed85]

I have a folder with 5-6 workbooks and each workbook has multiple worksheets.

I am trying a code to loop through the sheets in each workbook in that folder (which ever is selected on running the macro) copying the data from B:H and pasting the data in Mastersheet with Sheet1 name as "Consolidated List".

I tried and failed, I was able to copy from sheets to same workbook but unable to paste them in new workbook.

Please help.

Regards,
Sameer

 

[sjaveed85]

Please help with a link or the code