DA,

Glad you found a solution.

I can't resist replying to the points you make:

This is nice, too. But, if I change sheet1, I need to remember to
rerurn the macro to make sure sheet2 will change, which is not ideal.

If you put the code in the code page of sheet1 by using the following event:
Private Sub Worksheet_Change(ByVal Target As Range)

Then the macro will run when sheet1 changes

Also, there will be a few cells from sheet1 that I will not want to
show on sheet 2.
I actually wanted the macro to initially set up the new sheet, ay
which point I would edit out a few cells from sheet 2 and, perhaps,
format a few diffferently. I think I'm there now, so I think this is
all good enough.

You could set up code to do all of this and more on selected ranges of
cells.

There, my conscience is clear!