Dear All,

I have 95 excel workbooks each having 9000 to 18000 rows of data. I need to
prepare 1 consolidated excel workbook which shows all the data taken from 95
excel workbooks. I know the import option but it imports only 1 workbook
each time. Is there any option to import all the 95 worksheets to one single
workbook at a time? If the imported data is more than 65000 rows it should
import to next sheet. Any option?

Thanks in advance.

Narendar