I guess I'm being a bit dense, but I don't see how this would work. I have
the calendar template as my second sheet in the workbook, but I don't see
any way to automatically populate the cells. I can't even find a good way
to figure out what date each cell is so that I can find the several lines
in the main sheet that match that date and add those to the cell.

I have many more columns than this, but the basic information can be found
in the columns: Event, Date, and Start-Time. Each of these columns might
have several events happening on the same date that should appear on the
calendar in the same date box.

--David

?B?R2FyeScncyBTdHVkZW50?=
wrote in
:

The first step is to copy the template into your original workbook.
This makes linking much easier.

The next step is to populate the calendar template worksheet with
links back into your original complex calendar worksshet.

You can use things like VLOOKUP() to get information w.r.t specific
dates, etc.