on the sheets other than sheet1
in column A use
=indirect("Sheet1!A"&row())
and use Vlookups for the columns
You can then insert rows in sheet 1 and the references will reflect the
insertion in the other sheets

"rexmann" wrote:

Hi all

I have a spreadsheet with a number of sheets. on sheet one is a merge row in
column a with the heading and then various rows with the data

A N 123
B A 123
C M 334
D E 233

The first 3/4 rows are identical on the next sheets and are linked to sheet
1 (if sheet 1 changes the data changes).

However I may need to add a new row in sheet one (in example above a new row
between the 123 and 123. Is there a way that will update the new row on the
other sheets.

Any suggestions greatly appreciated

Rexmann

Ps I use Excel XP