Urgent VBA excel help! - reorganize data

Hello,
How do I write the VBA code to search Events by date and reorganize them into a totally different format in a different sheet?

Original spread sheet in each column:
Event Category(3 types) ,Starts Date (mm/dd/yy),Ends Date (mm/dd/yy),Event Title,Event Details, Contact Name, and Contact Phone #

Search command need to show as a calendar format:
Event Category (same category ones show as one category), as rows

Next 30days Events, next 60days Events, Next 90 Days events, and 90+ days Events. as column.

and the Event Details, Contact name & phone number all will be combined and added in Event Title cell as comments.