Copy rows from 1 sheet, to multiple sheets

I have a workbook I'm working on in Excel 2007. Sheet 1 has a list of students, location, dates attended, test score and so on. I want a function that will search column A (which is the location) and put each students info (the whole row) onto a different sheet. Each location will be on a different sheet, with all students and all there info on that sheet.

Example:
A B C D E
Location Date Start Date End Score Name

Washington Jan 1 Jan 10 92% John Doe
Florida Jan 15 Jan 25 100% Jane Doe
Florida Jan 15 Jan 25 96% Jim Doe
Texas Feb 1 Feb 10 92% Joe Doe


As I add more entries into sheet 1, I want it to autofill the same info to another sheet.

All Students from Washington on Sheet 2
All Students from Florida on Sheet 3
All Students from Texas on Sheet 4