Newbie problem

I apologize if this question seems simple. I am a novice at Excel. I looked through the Help file to try and resolve my problem, but nothing seems to work. I have several subset groups of data in a spreadsheet, sorted by name. Some groups are four rows, some three, some two, and each subset group is totaled at the end of that subset. I want to be able to copy a new row of data from another spreadsheet and insert it as the new bottom row in one of my subsets, and have it automatically be included in the formula for the subset. I find that if I insert the row in the middle of a subset group, it becomes included in the formula and the new totals include the data. However, if I try to insert it directly above the subset total line, the data shows but does not get included in the formula or totals.

I would like to know how to insert it directly above the totals row and have it included, or how to move the row down to the bottom if I insert it in the middle so it does get included. Any help is greatly appreciated.