Automatically auto-fill cells, when inserting new row

Say I have two Sheets in a workbook. A and B. Rows from SheetA are used in formulas in Sheet B. When I insert a new row in SheetA, the formulas automatically change in Sheet B, and a row is added. The thing is that I have to drag and fill, the new row everytime, as it is empty. In reality, I have about 10 Sheets connected to SheetA, and I have to drag and fill the code for every single sheet everytime. Is there a way for excel to do this automatically?

Thank you very much in advance!

Allerdrengen