Using Excel 2003

I have a series of ~20 cells that may or may not have text in them
i.e.
A1:A5 - Report, Meeting, Reply, Recon, <
B1:B5 - Meeting, Excel Project, Reply, <, <
C1:C5 - Excel Project, <, <, <, <
D1:D5 - Meeting, Apples, <, <, <

< denotes an empty cell

I would like to have something like:
"Report, Meeting(3), Reply(2), Recon, Excel Project(2),
Apples"
to appear in another Cell. If need be, the count of the repeated
items can be dropped.

PURPOSE: a weekly synopsis of data entered as "Miscellaneous" on a
daily tracking sheet (each day has space for 4 items), Ideal solution
would also allow this to be reported on a quarterly, semi-annual, and
annual basis also; though that may be too ambitious/resource intensive.