Formula for automatic transfer of data from one sheet to another in Google Sheets

Question

I would like to ask for help with regards to my attendance sheet.

How can I automatically transfer the data from the remarks column on Sheet 1 to the date columns on Sheet 2?

The list of subjects on Sheet 1 is not sorted so I want the transfer of data to coincide with the sorted list of subjects on Sheet 2.

Sheet 1

Sheet 2

This is the link of my sheet:https://docs.google.com/spreadsheets/d/1y3kaOG_-xduw-Su2E4qKWNyFg70eW2qam98JwZ0vFEU/edit#gid=0

Answer 1

Put it to B4 and then copy and apply to C4:D4

=ArrayFormula(IF($A4:$A="",,IFNA(VLOOKUP($A4:$A,FILTER(Sheet1!$A:$E,Sheet1!$B:$B=B2),COLUMNS(Sheet1!$A:$E),FALSE),)))