I have a workbook with about 12 different sheets

The master sheet which is named "Weight Calculation" has hundreds of rows of data. I need to insert new rows anywhere within this sheet and for these new rows to be also inserted in two other sheets ("SOL Distribution" & " In Service Distribution") but not all worksheets.

When I insert the rows (to have a dialog box come up asking which row to insert and how many rows is required) I want it to copy down any cells which contain formulas from above but to remove any constant data.

The two additional sheets listed above directly reference back to the master sheet so i need them to have the whole row copy down formula from cells above

Hopefully this makes sense