Copy Paste cells into a new sheet based on criteria macro

Hi,

I'm using excel to format the results I get from Survey Monkey. In Survey Monkey I ask the person to identify who they are and then they are asked questions which are relevant to them. Each person has different questions and a different number of questions. The file I download from Survey Monkey has a column with the survey peoples names in it (say column A) under the heading 'Please identify the part of the business you represent.' and then has the questions in row 1, one persons after another. Then, each persons response is recorded in the row which correlates to their name and comes under their question heading. I've attached an example of how this looks in excel in this thread.

What I need to do is have a macro which takes the persons name (what comes under the heading 'Please identify the part of the business you represent.'), puts it into a new worksheet, and then takes the questions which relate to them and put the question and their response one under the other. So each persons responses will be on a new worksheet. What this should look like is on sheet2 of the attached file. I need a macro to do this as I'll be having a new survey to process every month. Also, there is the possibility that I will need to add questions or take some out, so if the macro can search for the responses and number of questions for each person, then it will work.

Thanks.