It doesn't, very much; it'd be better had you used more punctuation. Let me
try to rephrase and you tell me whether I have it right:

Sheet X is basically an input form: In cell B2 you have a dropdown list of
IDs, and in C2, D2 and E2 (you said D2 twice but that's a typo, right?) are
some "input boxes", by which I suppose you mean text boxes. Not sure why you
need text boxes when the user could just type into the cells directly, but
let that go: The user is expected to select an ID from the dropdown list in
B2 and then enter some numeric values for that ID in C2, D2 and E2. Each
time the user has entered the data for a single ID, your program should go to
sheet W2 of the same workbook, look up the row for that ID and add the values
the user entered into C2, D2 and E2 into the corresponding sums (we'll
pretend they're also in C, D and E). When the user has finished entering all
data for the time being, the program (or another one) should take all those
values totaled up on W2 and "update" - you didn't say how - corresponding
values on a third (you said "second" but we're already got two) worksheet
which I'll call Z.

Is that right? If not, correct it please. If it is, by what operation is
the data in Z to be updated based on the data in W2? Should it be added
again (and if so, why didn't we just add it to Z in the first place?)?
Should the W2 numbers replace those in Z? What?

--- "David J" wrote:
B2: is a drop down list of 40 Adlet ID Numbers, C2: is and input box of the
number adlets played based on the adlet ID selected in the drop down box, D2:
is and input box of the number of K2P's based on the adlet ID selected in
the drop down box, D2: is an input box of keythrough ratios based on the
adlet ID selected in the drop down box. Note all of the input boxes are
static numbers that require no calculation. now that this is in put this
information needs to be sent to the analysis work sheet w2: cell b2: needs to
have have the input information added to the previous number updated in this
cell from previous inputs again this is based on the adlet ID selected in the
drop down box each time. Now I need this info to up date each adlet ID on the
second work sheet based on the input information from each drop down
selection.

I hope this makes sense.