Combine and filter multiple workbooks into one results

[Frankrizzo83]

Please excuse the double dipping, I posted this question at another excel help site, unfortunately I haven't had any takers. Here's hoping I can get some help here!

I've got 21 workbooks that I'm currently dealing with.

Two workbooks (A1, A2) has specific names that are needed for the results page.

19 workbooks (B1-B19) have ALL (too much!) of the names in the office. Importanly, it has a "Start, Done, Last Completion" column for that particular course (name of workbook).

I am in need of two "results" workbook/sheet that only displays the names located in A1 and A2 workbooks. The "results page" should also have the "Start, Done, Last Completion" column data listed from the other 19 workbooks.


"Standard operation" involves manually filtering each of the 19 workbooks to only show the names of those in A1, then re-doing the same thing to show only the names in A2.
With the information, I then build up two "results" work books that have the names of individuals from A1 (and another for A2), with the name of the course (name of actual workbook B1-B19) along with a "start", "done" and "last date completed" all taken from B1-B19.

Please let me know if you need more information!