Im clear on what I want to do, but I dont know how to proceed.
I need a macro that will:

1. Read WorkOrderNo from a list of work orders starting in cell B6 in
Dest_Wksht
2. Find all instances of WorkOrderNo in Source_Wksht that fall on Date1
(Monday), and populate cell C6 in Dest_Wksht with the total hours worked for
that Work Order number on that day.
3. Repeat for Date2 (Tuesday) thru Date7 (Sunday)
4. Repeat with cel B7 from Dest_Wksht thru until end of list

Where do I begin?
Thanks for any help.

Source_Wksht looks like this:
A B C D
2 Work Order Time In Time Out Time elapsed
3 1221 10/21/2008 10:03 10/21/2008 12:16 2:13
4 1221 10/21/2008 12:36 10/21/2008 15:58 3:21
5
6 1223 10/20/2008 14:21 10/20/2008 16:27 2:06
7 1223 10/21/2008 8:00 10/21/2008 10:03 2:03