If the sheets are all in the same workbook, select sheet 1, select the
line where you want to insert a line, select all the sheets and perform
the insert. Excel will insert a line at the same point in all selected
sheets. If you right click a sheet tab you can select "select all
sheets".

Hans