Using SumIf Across Multiple Worksheets - Excel 2003
 

I am trying to create a Summary Page for data contained on 8 other worksheets
in the same workbook. There are 8 categories or items which need to be
totaled by month. The data is contained in 8 daily production reports (1
report for each employee)

Production Report Sample:

Item being Tracked1
Date Qty Hours Avg Hr/item
10/01/09 5 2.5 .50
10/02/09 3 .75 .25

I would like the summary to look up the Qty for each month on, and total it.
I've been trying to include the date range in a SumIf, but cannot make it
work, even if I name the ranges.

Any suggestions? Is SumIF NOT the way to go?