Excel 2007 : Need help making a summary workbook that pulls information from other workbooks

I am trying to make a separate summary workbook that pulls data from all the workbooks (Excel files) in a specific folder, and places it into the new summary workbook. The source workbooks are all formatted identically, and just contain different data. What I need the summary workbook to do is:
1. Pull data from workbooks in a specific folder as long as the workbooks were last modified within the past week (only workbooks that are a week old or newer). If that's not possible, then I'll just hand-place only the recent workbooks into the folder.
2. Enter the date of each workbook in the first column in the summary.
3. Enter the corresponding name of the workbook in the second column (such as "workbook.xlsx"). The name of the workbook serves as the "Project Name" in the summary.
4. Pull the following cells from a specific worksheet named "Totals" in each of the workbooks. The cells are: B1 for the third row in the summary, and G37 for the fourth row in the summary. B1 serves as a person's name. G37 is their dollar amount.
5. The summary workbook then needs to (somewhere) create a list of each person's name it finds in B1, and indicate the number of times those names show up (instances). For example, if it finds the name John Doe eight times, it will indicate that John Doe shows up eight times.
6. Add up all the dollar values (G37) associated with the names (B1). So if John Doe appeared eight times, it would add the eight dollar values associated with John Doe and give a total of John Doe's dollar values.

The result is that I'll have a project's date, project's title, name of the person who's project it is, and the dollar value of the project. Then it will calculate the number of projects each person has, as well as the grand total dollar value of each person's collection of projects.

So far, I've been able to get bits and pieces of this working, but am trying to find a way to make all of the parts work at once. If I need to explain anything more, please let me know.
Thank you for any help.

[Solved using an add-in as well as PivotTables]