Combining sheets from multiple workbooks into master

I promise I searched, and tried to modify some of the vbscript I found here on the site that did similar things, but have not been able to make this work.

I have several workbooks that supervisors in a call center use to grade calls for quality.

Each supervisor has a seperate workbook, and after scoring the call, the supervisor runs a vb script that copies all of the data from the worksheet "observation" onto "sheet1" for storing the data.

So now I want to use another workbook to:

1. Copy each sheet1 from all of the supervisor workbooks onto a sheet named "cumulative" in a different workbook.

In a perfect world it would also:
2. Keep a count of how many observations were done by each supervisor each day
3. Keep a count of how many have been done week to date
4. Keep a count how many have been done total since January 1, 2009

Each workbook is kept on a network drive at s:\supervisors\qadata and named - for example QAformMelissa.xls

I'm okay with keeping the master sheet in the same directory if that makes it easier to accomplish this.

I've attached a scorecard workbook and the "master sheet" if that is helpful.
the scorecard is "fake" because the actual was larger than allowed by the forum, but hopefully you will be able to see what I'm doing.

Thanks much for taking the time to read and consider.