Perhaps something along these lines ..
Assume a sheet named: Master
In the slave sheet
Put in A1:
=OFFSET(Master!$A$1,ROWS($A$1:A1)-1,COLUMNS($A$1:A1)-1)
Fill across and down to cover the max expected working range that the sheet:
Master is likely to have, inclusive of any possible future insertions of
rows and columns within the initial / existing working range in Master (The
formula will cater for any future insertions of rows or columns *within* the
covered range after set-up)
For a cleaner look, you could suppress extraneous zeros
from showing in the slave sheet via:
Tools > Options > View tab > Uncheck Zero values > OK
Note: Though you could of course, try filling the *entire* sheet (256 cols x
65536 rows), it's NOT advisable, to keep calc speed and file size within
reasonable bounds.
Copying Formats
-------------
Copy the initial working range in Master
Right-click on A1 in the slave sheet > paste special > formats in the slave
sheet.
As any formats/formatting done in future insertions of new rows / cols,
and/or in existing rows/cols in Master after the initial copy format above
is executed within the covered range will *not* carry over automatically to
the slave sheet (unlike the cell values), you'll have to repeat the copy
formats as and when this happens to ensure identicality.
