sending calculations from one sheet to another to make reports

[amahrouf]

Hi I now have a nice program that performs all my calculations once the data is entered.
I now want to make a report. I tweaked it on a landscape for my 6-8th grade on seperate sheets and need to send numbers data from calculation sheets to either the 3,6, or 9 week sheet so a report can be printed when all other data is ready.

i hope this is clear because I can't paste it here to give a visual
Thanks

the teacher

[amahrouf]

I have a workbook with 6 sheets. One for each class 6-8 and the 3, 6, 9 week reports.
Each class sheet does 4 calculations for a test taken every 3,6,9 week. I would like those calculations to go to the corresponding report page.

I tried looking at other posts and I really don't understand the codes or links and where to input them. I tried to put the letters in the boxes. to send the info to another sheet but not working.

Thanks