Thanks Haseeb...

But i want to generate report cards for the students automatically....
As soon as a student's grades are generated, the program should automatically generate a report card...

Think of it as a Report Card template... I look up for a student and the template should be able to access all the worksheets in that workbook and show me only that student's grades...

Thanks again...