Lets start into the details-

Consider there are 3 Ms Excel 2007 files. I.e,

1 Student file
2 Department File
3 Teachers file

Student file in turn contains more than 10 sheets, each sheet contains particular information about the student like, student's age and demographic information, Previous education, Parents education status etc.

Department file contains more than 10 sheets, each sheet contains specific information like department details in 2002, department details in 2003, department details in 2004 etc.

Teacher's file contains more than 10 sheets, each sheets in turn contains specific information of the teachers.

We needs to prepare a single excel file with the name my_school details.

Copying the data is a tedious task, any ways every one can do that. But, I need to know how can we merge all these files to a single file???

Kindly let me know whether we can achieve this MS Excel?

Thanks,
Balas