Pull data from weekly report and post to running spreadsheet

I have never written VBA before and I need to pull specifics from a report that can be pulled as txt or as xls. Is there a way to write this?

I need the following data from the attached spreadsheet to be put in a running list of weekly productivity reporting:
The date (only the date, not the time) next to "From" in column C
The names (only the names, not the " - Loan Operations") with the corrosponding heading of KTM Document Review or KTM Validation in Column B
The total Sessions for each person pulled

The data can be dumped into the next available row of the worksheet in the following way: Column A=date, Column B=Header, Column C=name, Column D=total.

Any explanation on how this can be accomplished would be appreciated.
Thanks.

Should I be looking someplace else for the answer to this? Or perhaps my request is unclear? I really would appreciate help on this as I'm stuck.
Thanks.

Ok, I figured out how to get the data from one sheet to the other in the order I want. Perhaps someone can now help me make it so this macro can be applied to any sheet that is opened with the following name: "week of **-** to **-**".xls.

I also want the macro to apply to the next empty cell in column A...is there a way to write this?