I want to create a sheet2 and, between cells A1 and P200, any time
that sheet1 has something in one of those cells, whatever it might be,
I want sheet2 to simply reference that result. If sheet1 is empty in
that cell, then I want sheet2 to also be the same.

It seems that the easiest way to do this would be to make a copy of
sheet 1, name that sheet2, then have a macro that replaces its
contents with =sheet1!A1, if we are tlaking about cell A1, for
example, and so on and so forth.

I suppose I could simply set every cell in that block eqaul to it, but
I fear that I will have a bunch of zeroes showing up on sheet2 in
places where sheet1 is blank. Please keep in mind that empty cells in
sheet1 may have all sorts of unknown formats in them, so I can't just
assume that if a certain cell is blank in sheet1 that it will remain
balnk in sheet2, if I just paste sheet1 formats onto sheet2, but the
cell format happened to be, say, "currency". The blank would show up
as 0.00.

Yes, I am open to other, more clever, ways to do this, but it seems
like a macro as described above would do the trick.

Can someone kindlty help me with such a macro?

Thanks
Dean