Capture Billable Expenses & Non-billable Expenses To Timesheet According To Date

I am trying to capture billable and non-billable expenses in a time sheet by date. I thought it was pretty simple, but after a few days of battling with the syntax (I am pretty new to macros)

I have attached the file I am referring to and highlighted in yellow the significant cells.

1. Trying to get data from the all expense sheets to the "Time Sheet" Tab by date and category.
2. Need to show the billable expenses expanded out to each category (meals, hotel, etc.) by date.
3. All nonbillable is summed up in one column by date.

June expense report has:

Date of ReceiptExpense Type "Billable? Total USD
01-Jun-08 Airfare Yes - Recoverable$2,000.00
01-Jun-08 Airfare Yes - Recoverable$2,000.00
01-Jun-08 Ground Transport No - Training$20.00
05-Jun-08 Meals & Entertain Yes - Recoverable$15.00
05-Jun-08 Meals & Entertain Yes - Recoverable $50.00


1) There are TWO June 1, 2008 items that are "Airfare" & "Billable", therefore in the "Time Sheet Tab, I need it to show that under "Billable Airfare" for June 1, 2008 that it is $4,000.

2) Same as June 5, 2008 for Meals & Entertain.

3) All Non-billable (No - Training; No - XXXX; anything with NO) are summed up in one column by date in the "Time Sheet Tab"

4) There are multiple Expense reports and I need the macro to run through all of them dynamically as they input the data in to show on the "Time Sheet" tab.

This would make my job a lot easier if I could get this running. I dont' think it is too complex, but obviously too complex for me. I started on some of the vba below. I do not have all the parts yet, weird thing is, it did spit out a number, but now it is not. I'm at a loss.
...................................