Excel for Mac saving formulas

I am trying to get a quick was to add a formula to a spreadsheet.  I have a spreadsheet that I enter a code into Column A and the formula in Column B to E allow those cells to be auto-filled lining up with a master sheet.

If I add another row it does not automatically add the formula and I have to copy and past it.

Is there an easier way, such as a way of saving the formula into a preset so I only have to select the row I want the formula added too and click on a preset?