Copy data from several sheets to one to make a summary

Hi,

i am new to VBA and wants to do the following:

I have a database in sql server 2008. In this db there is a table that got the results of a survey.
It only registers the number of a question and the number of the answer and a contact id.

So what i am about to do is, i export the result data from that table into the Excel 2010 workbook in an Excel worksheet that already excist.
Now in this workbook there are several worksheets that contain the text of all te questions and Answers with there numbers.

So how can i get the right Question with the right answer for the right contact id?

Example:

Customer 1: contactid = 0001 his/her question is "Are you satified with the service delivered?" Her answer is Very Satisfied.
Question has number 1 and answer has number 5

Questions are at tab/sheet Questions
And Answers are at tab/sheet Answers.

How can I get this information in one row at the worksheet Survey with VBA?

Thanks

Wim81

Could you post a copy of your file? It would be easier to help.

I have uploaded the file

Thanks

My apologies. Could you please change the headers in row 1 of all the worksheets to English and post the revised file? I am having a little difficulty interpreting which are the questions, answers and contact ID.

I can't upload a second file? :s

Hi Wim81. I find it strange that you can't upload a second file. Perhaps you could try again re-naming the file. It's difficult for me to help because of the language problem. It would help me if the column headers and tab names were in English. As well, where are the customer ID's? Which sheet has the customer ID, question number and answer number? If you can't upload the file, perhaps you could include the translations in your post.