collecting data from multiple workbooks

Hello

I have created 3 workbooks for work.

1: A survey to be answered by 40 staff, it has 30 questions with answers being numbers of 1 -10. Currently each person has the same workbook emailed out to them - only difference is each workbook is named - whatever their name is - so i would have 40 identical workbooks with individual names coming back (I am so open to a better way on this - yes each persons data is private...)
2. A second work book with the same questions/survey above to be answered "about" each staffer from the manager. This one contains all their names on one sheet, in columns - same as above but with all staff names rather than the one in the same book.
3. Finally a third workbook where by i have managed with index and match to bring in all the data filled out in workbook 2 for a specific staff member/column when their name is typed into cell b2.

My problem now is with workbook 1 - which is the questions sent out to all 40 staff members, that is how can i auto-populate the 3rd workbook with their answers from the 40 workbooks they will email back?
They all would get the xls questionnaire emailed to them in xls format, workbook titled with their name in on, is this way to much, to messy?

Any ideas at all would be wonderful and if you cant advise I totally understand, its a act of desperation.

Regards
Isabella

Cross-posted here: Ozgrid

It's not locked permanently. As stated in that post, send a PM to the moderators and they will unlock your thread. All free forums have rules about cross-posting so you will likely get busted here once a moderator views this thread.