Are you talking about separate files or multiple worksheets in the same file?
If it's the latter, If you hold down the shift or control key and click on
the tab for each worksheet you want to activate, then when you insert rows,
or add data to your main sheet, each sheet that has been selected will be
updated accordingly. I don't know if this meets your definition of
automatic. Search for "select on or multiple worksheets in help. I don't
believe this can be accomplished in separate files and I haven't tried it.
"Andrew" wrote:

I have a number of linked worksheets & would like to know if its possible &
how, to insert a row into one sheet it will auotmatically insert a row into
the corresponding linked sheet with the same formatting. Ideally it might
also allow for automatically updating the numbering (in the 1st column)
similar to when inserting number bullets in word.

Any suggestions & help appreciated