Assume you are doing this manually:

group the appropriate sheets before you insert the rows and put in the
formulas.

--
Regards,
Tom Ogilvy

"frank.freeman" <frank.freeman@discussions.microsoft.com> wrote in message
news:57B2254D-AFB7-4AA0-B7EE-ECE701208750@microsoft.com...
> 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
>
> f.freeman@usa.net
>
>