VBA to copy and paste dynamically from one worksheet to another

I am building an excel database to keep track of our students' progress in our Eye Level Learning Center. We have a worksheet (Lesson Plan) that is filled in from a student worksheet named by the student name. In the Lesson Plan the information on the first page is pulled out of the student's record worksheet dynamically by the student name in B1 and the lesson number in A4.
What I need to do is copy and paste the information on page 2 of the Lesson Plan into specific cells in the student worksheet in a row of cells determined by the lesson number. I need a macro that will do this. I have tried to build it by recording the macro, but it needs to be dynamic and my knowledge of VBA is limited.

I have a temporary file with those two worksheets and the cells in question highlighted.

Thanks for any help you can give me.

Sorry. I need to give you more information. The cells from the second page, Lesson Plan, are highlighted; D37, G37, D40-D42, D45-G45, and D46. These need to be copied and pasted into page 1, New Student (The name of sheet will be the student name found in B1 of the Lesson Plan), in the array, AP4:AY177 in the row where the lesson number in col AP matches the current lesson in A4 of Lesson Plan. Then the data in the cells Lesson Plan, D40-D42, D45-G45, and D46, will be cleared and D37, G37 will be reset to "No".
I need a macro that will do this dynamically. HELP.