VLOOKUP loop multiple times

I am trying to help an Analyst at a police department. She is trying to
search crime data in Excel and put it into a calendar. I found an Excel
Calendar on Microsoft's web site, each day is one cell. I then put a
VLOOKUP formula that goes to another sheet and returns the crime based
on the date. i.e.

8/1/2005 FALSE INFO TO OFFICER
8/1/2005 N&D/PARAPHERNALIA
8/1/2005 MUNI CODE/SOLICIT W/O PERMIT
8/2/2005 ASSAULT WITH DEADLY WEAPON
8/2/2005 BATTERY/SIMPLE

The problem I can't figure out how to Loop the formula multiple times
and CONCATENATE the results so I can paste them back into the Cell that
contains the date.

Any Ideas?

Lenny

I don't think i explained it good enough let me try again.
In Sheet2 I have the following crime data and it could be a couple of
hundred rows

8/1/2005 FALSE INFO TO OFFICER
8/1/2005 N&D/PARAPHERNALIA
8/1/2005 MUNI CODE/SOLICIT W/O PERMIT
8/2/2005 ASSAULT WITH DEADLY WEAPON
8/2/2005 BATTERY/SIMPLE

I am in now back in Sheet1 Cell A1 I want a formula that will read
Sheet2 and Concatenate all the info for the first date like this into
one Cell
FALSE INFO TO OFFICER
N&D/PARAPHERNALIA
MUNI CODE/SOLICIT W/O PERMIT

I will write another formula that will put then data from the next date
into anohter cell untill I have all the data for the month.

I showed her how to do this with a pivot table but she wants it to look
like a calendar.

Thanks Again,
Lenny