I am attempting to creat a workbook in excell 2003 pro which contains several
worksheets. all of the worksheets contain the same names in the first column
and the data in the following colums is manipulated with summeries of the
columns on the last sheet. that part is not a problem. my problem is that if
i add a row to the first sheet in the middle of the rows of data i need the
workbook to add the rows to the other sheets in the same place mailtaining
the same formulas/relationships.

any help would be appreciated