Hi,
My objective is to automatically generate a report using Excel based on the answers of a questionnaire form.
That is, I plan to have a separate online questionnaire,be which will export the data to a excel file with the following data:

Name:
(and other personal info)

q1. Option - "__"
q2. ...
q3. ...
and so on.

Next to this data will be the survey counter in another column. This value will increment for each survey entry (that is, survey counter will change from 1 to 2 for the data of the next person to take the questionnaire.

Now, I also have a second excel workbook to generate a report based on the questionnaire answers of each person.

My problems are:
1. Making the first excel workbook to export the data of the questionnaire separating each entry automatically.
2. Allowing the second excel workbook to read the data entry-by-entry from the first excel workbook and to save the assembled report to a new word document with a unique name (for each entry).

I have a limited knowledge of VBA, but I'm a quick learner and can adapt code used in different situations to suit mine.
Can I find a workable solution to my problems using Excel?

Please help me if you can.
Thank you!