Auto transfer data as i marked

Hello,
I have a spreedsheet where there are names, enrolment No., various subjects(1st Year, 2nd year & 3rd year) of at least 10000 students related. They are submitting assignments in every six months and now i want to ask a question that if i marked '/' in a cell after subject code, is it possible that the particular student name & enrolment No. automatically paste in the other spreedsheet under the particular subject code. Pls inform me.