That is quite a general question. Care to provide more details?
How does your student result sheets look like?
How do you want the result to be presented on your report sheet?
To clarify what you are trying to achieve, consider posting screenshots or upload your workbook using a free file sharing site and then post back the download link. Always be carefull with sensitive data.
Try to be as clear as possible, preferably with details of which data needs to go where.