I can already tell this is going to be difficult to explain. Perhaps
I'm asking in the wrong place or even asking too much from a program,
but here goes:

In short I'm doing this what I consider "the hard way" because that's
how the brass here wants it done. I have an excel file that is simply
a chart with 10 columns and about 100 rows at any given time. This
file is to keep track of meetings that my team attends. Going across
the top, the columns are labeled with date, time, meeting title,
location and things such as that. Each row is a different meeting kept
in chronological order. I add new meetings as they are scheduled and
paste old or cancelled meetings into another worksheet with a new tab
and the same columns set up. Each day I print the calendar (one page,
landscape) for the week we are in removing the meetings that we have
already attended that week.

I would like to set up a third sheet as a "rolling" calendar that would
be less detailed than the first sheet in that it would have less
columns and a more narrow row width. For this sheet I would need only
date, time, meeting title and location. I imagine this fitting on one
page portrait style.

Is there a way that I can make page one copy to this page 3 and
automatically update it as I change the contents of page 1?

Thanks!