How to merge two Excel files.

[Brijesh]

i m using office XP, i have lots of data in different excel files, each
files include two or three worksheet, and all worshett are in different
layout,

how to merge all this excel files in one excel files, is there any kind of
facility in excel ....?.......can any body help for that........?


Thanx in advance,


BrijLo81.

 

[Serkan]

right click menu on sheet name,

"select all sheets"
and
"Move or Copy"

so you can move or copy all sheets to a new book or
another workbook