Automatically auto-fill cells, when inserting new row

Thank you for your response!

I have now uploaded a before and after workbook. In the after workbook under "Data", I have added a new row (19). I have then inputtet my desired data. The sheets "May", "June" and "July" get their data from the "Data" sheet. The problem is that upon adding the new row, the functions doesnt apply for the new row and I have to manually click and drag the data for all of the different sheets for the new row. I have to do this for the data in the columns A-C, but also from AM-AX(which gets it data from the sheets itself). The after workbook is how it should look upon adding the new row and inputting my desired data in in the "Data" tab. I would like the other sheets to adapt to this data. Is this possible?

Thank you so much in advance.