Using Excel 2010.

Hi forum. I've been working on some macros lately but I'm definitely no VBA expert. So I'd like to seek some help here.

I have multiple workbooks in the same folder with 2 worksheets in each:

- Summary

A B C D E
1 ID Dealer Location Course Name Course Type
2 CIV001 Civic Manila Warranty GEN
3 CIV002 Civic Manila Basic Mechanics TECH
4 CIV003 Civic Manila Basic Computer IT
5 CIV004 Civic Manila Advanced Mechanics TECH
6 CIV005 Civic Manila Warranty GEN

- Participants Name

A B
1 ID Name
2 CIV001 Tom
3 CIV001 Henry
4 CIV002 Carol
5 CIV002 Michelle
6 CIV002 Tom
7 CIV003 Alan
8 CIV003 Ben
9 CIV004 Charlie
10 CIV004 Peggy
11 CIV004 Alan
12 CIV005 Henry
13 CIV005 Michelle
14 CIV005 Ben


Let's say, I wanna create a macro that will extract IDs CIV002 to CIV004 from both Summary and Participants Name from all the workbooks into a new workbook with 2 similar worksheets. How do I come about to do it?

Thanks a lot!