Pull a row from an Excel survey into another sheet by a given variable

I created an Excel Survey and placed all the data into a sheet called "Main". The columns are the questions and the rows are the individual data points collected. I have been trying to figure out how to get the data sorted out into individual sheets for each of the teachers in the survey. One sheet per teacher within the workbook. I have tried to set it up so that I enter the teacher name in A1 and pull each row from "Main" into the sheet if it matches A1. Then I would copy sheets for each teacher in the survey. I have tried vlookup, index and i attempted to follow a macro from the forum, but failed miserably. This is my first time with the forum so any help would be wonderful. Thanks.