Excel linking to worksheets

I have a workbook with 5 worksheets. One column has a school code entered. I would like to find a way to have the data in a row automatically copy to another worksheet by using the school code which should tell it which worksheet to copy to depending on the code in that cell. Is there a way to do this?