Ron,

Seems to do exactly what I requested. However, I neglected to tell you the
reference numbers in Summary Master are in Column D, and the results for DPP
Q2 should appear in Column O. If you let me know what changes in the code are
necessary to get this result, I can then use the same code for all the other
workbooks that I need to drop the same type information into the Summary
Master.

Again, many thanks for your patience and help.