Help with Sum and Index from one sheet to another sheet!

[Brian.Aerojet]

I hope to explain this so everyone can understand it.

I will add Example Attachment to help understand what Im needing to figure out

1st - I have numbers on one sheet that add together and then subtract together in many different ways.

The examples in attachment should help explain

Each set of numbers have 4 numbers in a D column and N column

I only need the Colored numbers looked at.

I have sheet 1 with the numbers, and then results will go in sheet 2.

The problem Im having is after I get all my numbers for adding and subtracting in the 1st set of numbers, I can't copy and paste to the 2nd set and get correct results based on numbers from sheet 1.

If I could figure out the formula for the sum of my 1st numbers then as I add more to sheet 1 I can just copy and paste on sheet 2 and it will automatically give me results.

Thanks In Advance,
Brian