I'm intending to make a survey using excel. The plan is to send excel sheets which contains the questions via e-mail to a group of people. They will then fill in the sheet and send it back to me. Is there any way to code a macro that could handle the data collection from the files? What I mean is that if I save all the sheets sent back to me in one directory, how do I collect the data from all of the excel-files say from question number 4 and present the results in one "results" -sheet? There will be a lot of answer files sent to me, so gathering the data manually one by one would take too much time!