update two or more excel documents and must be scalable

In my excel file, I have a list of students and the test marks of their subject arranged according to the semester. Also in the same file but in a different sheet, I have a list of subjects arranged according to the individual student. What I want is when I update the marks in the semester section, the marks will also automatically update in the student section. And after the individual student section is updated, I would like to have a button in which when I click it it will generate an academic transcript.