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