vba to copy from multiple workbooks to a summary sheet in another workbook.

Could you supply us with some sample workbooks? It would be great to get 2 or 3 audit workbooks along with your Summary workbook.
Are the 200+ files located in the same folder? How are they named?

I uploaded 4 files. The summary sheet repeats the group names for ease of editing but in the actual summary sheet each group name is unique. The files are all located in the same folder.
The 200 + files are named by the unique group name and the quarter for which the responses are in.

Thanks for your help!
Lisa

I'll take a look at this later on today but can you tell me if there is a standard naming procedure for the audit files. From the sample you supplied, It does not seem as you do. We will have to search for the auditor name along with the quarter the audit was done and it would be a good thing if the name of the file could give us those information always at the same place and with the same format. Is this possible?

I think I can see that quarters will be Q1, Q2, Q3 and Q4. Right?
What about the groups? How many characters? Can you place the group characters always the first ? ones of the file's name?
Will there be only audit files in this folder? If not, we need a way for the macro to distinguish the audit files from the other ones. Something like the word AUDIT in those files' name and this term will be prohibited in any other file's name.

I don't understand how those 200+ files are related to a specific auditor like I see in your Summary sheet. May be this is only in the Summary sheet.

Would it be possible to give me a Summary sheet that would be more realistic (like no replicate in group, etc.) and 3 audit files that I can work with (Files with proper names "group Q?.xls")?
It think it should be obvious where each numbers go where?

About your 200+ audit files, are they from different year? Do the macro have to fill in data for every quarter or just a specific one?

Lots of questions just to get started but after that is cleared, it should be easy.

Okay. I changed the names to protect the innocent : ) but I think this will help.

The 200+ audit files are for each quarter. For example we audit A Group, B Group, C Group and so on every quarter in 2014. We will then audit those same groups in 2015. A seperate folder would be created for 2015. Each quarter we would update the summary sheets once the results come in for each group. So A Group, B Group, C Group, would all populate Q2 right now. In September those same groups would populate Q3. The macro would need to know which quarter so it could populate the correct cells on the summary sheet. Let me know if that makes sense?
Thanks

Hi Lisa,
lets try the attached workbook and tell me if it words like you'd like it to.
You have to run the macro named Get_Responses.

I found that your B group workbook that you supplied has the result we are looking for at L96 and L97 instead of L98 and L99. You should take great care to have all the sheets exactly the same or the results will not come out.

If you fear that this could be the case, we could search for the results by its tag in K98 and K99. In this case, the actual tags (met and not met) are probably not unique enough for this task. We'd have to come up with something more specific that we are pretty sure not to find in other cells.
Regards