I have a spreadsheet which is going to have 30+ sheets, of which the top
20(ish)rows are going to contain identical data (milestones dates and
description). I am looking for an automated was to have the same data on each
sheet, rather than have to change each sheet when a date changes, or do the
laborious copy and paste to each sheet.

I wanted to use a formula in a range say A1:M20, and in each cell put
A1=Sheet1!A1, A2=Sheet1!A2
and so on. However this picks up blank cells and displays "0". I have to
pick up the blank cells as at a later date they may contain data. Is there
something I can put in the formula to ensure blank cells are not copied. I
can't use macros as the system doesn't like them and am also trying to avoid
using
A1=IF(Sheet1!A1="","",Sheet1!A1)
as this seems to put data in the cell therefore not allowing the formating I
require.
Any ideas greatly appreciated.
Cheer Laura