Need to automatically insert new row including formulas

Have tables with 25 rows for data that the boss wants the option of adding more rows. Rather than inserting a row I would rather put a "button" with "New Row" where when clicked a new row is inserted above the total row with the formulas and formats of those above it.