Excel automating next line

I have many excel workbooks, say from 10 to 30 colums across, and many rows, and some colums are formulas and some are input fields.

Rather than always having to copy the next 10 rows or so of formulas, and having empty rows , I would like that when I complete a row of input, at the end it would automatically copy the formulas down to the next row.