Import workbook as worksheet in the active workbook

Hi All,

Juz need all ur help in importing workbook as a worksheet in the active workbook which contains the macro code...

I have a number of excel workbooks in the folder. Those workbook contains 10 worksheets. All of the workbooks has same worksheets name. I juz need the only one worksheet "Updated Data" from all of the workbook to be imported as a worksheet in the active workbook "Main"...

Note : "Updated Data" is the name of the worksheet which is in all of the workbooks

Thanks in advance for spending ur time it...

Hi Roy,

I want to import only the "Updated data" worksheets from all the work book into the active workbook as separate sheets...

Scenario - I have main workbook which has only one worksheet called " MAIN" and 20 other workbooks in a folder..all the workbooks have a sheet called "Updated data"...I need the updated data wworksheet to be placed as worksheet in the main workbook...finally the main book shoud contains "Main" and 20 "updated data "worksheets in it....Totally 21 worksheets should be in the main workbook