I've been trying to solve this problem with functions and I just can't get it
to work, I was wondering if any of you programmers out there would know an
easier way.

The problem:
My data comes in with tons of extra cells and is really hard to quickly use.

The solution:
I need to make a macro that will summarize the data into the format on
sheet2 of the following example workbook:

http://students.washington.edu/rdorn/ExcelProblem.xls

Sheet 1 shows how the data is sent to me.

The company I work for has about 150 employees so this is just a sample.
One of my big problems is that we are broken into teams and I can't export
the data for just one team. So I end up having to browse the entire exported
file to extract information for the people I want to see. Is there a way
that I can manually enter the name of the employee on sheet 2 and enter the
dates, and then just run a macro to do this for me? Any and all help would
be much appreciated.

When I tried to use functions to do this I kept running into problems
because the data isn't always in the same place (but its always referenced in
the same way to the word "Agent:" as shown in the above sample). Not to
mention if an employee didn't come in then there is no exported data so my
function would jump to the next employee and use their hours (which obviously
messes everything up).

Thanks,
Dorn