Hi Balas,

Yes, you can put all those worksheets into a single file. The simplest method is to open the one with the most worksheets, then cut & paste the worksheets from the other workbooks into it. Unless you have a very great quantity to do, it would probably take less time to do it manually than to write code to automate it. And, if it's a once-off exercise, the effort involved in developing the code probably wouldn't be worthwhile.

What you should be considering is moving away from Excel to a database like Access.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]