Find string and return value from different files

[ssroy]

I have 12 files of 12 months marks. I have monthly test result on this 12 file. One another file (MANUAL.XLS) contain the details of the students.

Now I want to make one another file where I will select the student name and Marks of the student will be taken from all 12 months marks file automatically where student name is same.

For example 12 months marks files are JAN.XLS, FEB.XLS, MAR.XLS......DEC.XLS
MANUAL.XLS contain the details (DOB, Fathers name etc...) of the student.

Now on MARKSHEET.XLS file I want (On A1 cell I will select the student name from drop down list):
Find A1 ON FILE JAN.XLS AND THEN
JAN.B1=MARKSHEET.B1, FEB.B1=MARKSHEET.B2............
JAN.B2=MARKSHEET.C1, FEB.B2=MARKSHEET.C2............

Any solution please....