Excel - Looking For Subject And Copying Attending Student?

cannot seem to get a function that works.

I have a sheet named "Master" with student reference numbers (A2), student names (B2/C2) and their four subjects (D2, E2, F2, G2).

I need a separate sheet for each subject, so potentially 30 additional sheets, and i would like for where a subject is mentioned in one of the four columns of the master, the students reference and names would then be copied and pasted into a row on that subject specific sheet. Leaving the subject sheets with a list of names and numbers of the students studying.

So you would have a student on the master sheet and then they would appear on four additional subject sheets.

Ideally it would also update subject sheets as new students are added. And additional information is being added to the subjects sheets so they cannot be cleared.