Thread: Format:Copying cells from one workbook to another.

I have two excel spreadsheets composed. One is a questionnaire and one is a master. The questionnaire will be sent to a large number of people and the master will sum the information that is sent back from the questionnaires. I'm looking to create some type of a macro or code so that each of the responses can be entered into the master sheet automatically. There are 3 worksheets where information needs to be copied from, in each of these worksheets there is only one row that needs to be copied into the master spreadsheet (thus 3 rows total from the questionnaire workbook need to be copied into the master workbook). I would like to have it so that each desired row (colored in yellow, row 10 in two worksheets, row 11 in the other) from the questionnaire worksheets is put into the master one on top of the other in the corresponding worksheets. For example, since the information that the individual is filling out is on row 10, if there are 3 people that fill out the survey.. the master sheet should show each persons information in a seperate row, being row 10, 11, and 12. I have attached both of these workbooks, which include what I have done so far with minimal success. Any help would be greatly appreciated and if you need more information I will be able to respond very quickly.

Thanks in advance
Dave

Too complicated? lol

Hi
save the attached workbook in the folder containing data source(questions & answers). run the macro(tools > macro > macros > choose consolidate > Run). It will list file names in col A and their corresponding values from B to J.
Ravi