Adding and inserting new rows - Keep formulas

Hello everyone!

I was not bad in Excel before but I haven't used for a while so here I am..

My problem is the following: I want to add some rows within a sheet and keep the formulas within the same sheet and the next one, which is a summary. Here are a concrete example:

Assuming, on sheet 1, I have a section of rows from #24 until #29, I have manual data in columns C until AA, in which column Z is a simple sum of previous data (sum of data in the same row). On sheet 2, almost same structure, but data refer directly to sheet 1 and are mainly formulas (multiplication combining two cells in sheet 1).

My question is: how can I do if, for example, I want to add rows in the section between #24 and #29, and avoid to manually verify the formulas in sheets 1 and 2 and be sure that all formulas still apply? I've heard that I can create some tables..

Solutions either directly in Excel or VBA (I used to code before on that) would be very appreciated!

Thanks a lot in advance

Please attach a sample workbook.

Hello RChad, thanks for your return. I don't know exactly how to attach an excel file but I've tried with a picture. How can I put the Excel file?

The idea would be to add, for instance, 20 new lines in sheet 1 (between or after the last row), and be sure that I don't need to verify and adapt manually each row in sheet 2; This example is basic in this case with one section (number of products sold), since it could be applied to different sections (for instance 3 sections: number of products sold, unit price and turnover)
Thanks! Attachment 668908Attachment 668909