Need help with gradebook

Hi, I posted before but didn't get a response. I think I was confusing. I have a gradebook set up in Excel (I'm a teacher). I want to do weekly reports. I have several sheets in the workbook (reading, math, writing, etc.). Each student has a specific row on each sheet (ie. John Doe is on row 5 on every sheet). I need some way that I can have Excel pull row whatever from each sheet, and show them on a single page that I can print out. So I can do reports on each student.
Thanks for any help.