Transposing single row to multiple columns between workbooks

Hello everyone!

I work for a preschool and I developed a spreadsheet to monitor our assessments. I have one spreadsheet that is an overall glance at a classroom and then another that is for each individual child. I need an easier way to transfer the data from the classroom report to the individual report. The data is in a single row for each child on the classroom report, but is in seven different sections on the individual report. To make it more difficult, the spreadsheets are conditionally formatted to three different age groups in order to color code certain scores. So there are three different sheets for each age group for the individual report, and three different types of formatting on the rows for the classroom report. Right now I am literally copy>paste>transpose each individual section for each child, which is going to take me weeks. I am attaching a sample of the classroom workbook and a sample individual workbook. You can see in the individual workbook in red where the data needs to go...there are four different columns and data will be entered four times a year from four separate classroom workbooks. If anyone has any ideas, please let me know! I am not very verbose when it comes to macros and VBA at all, I know there is a way to do this but I have no idea where to start!