Excel 2007 : Information merge from multiple sheets

Ok I'm going to need to publish this one to make sure I explain it correctly. Oh, Thanks in advance for the hard work and the help.

In blocks F45,F46,F47 will have a drop down box with.. example is 09-0001, 09-0002, or 09-0003, but they will not be in any specific order at any one time, but will always be in those three blocks.

In blocks E45,E46,E47 will be a total number that I will manually put in, but if I change, from the drop down box, in F45,F46,F47 I need that manually inputted number to follow that specific listed number.

Then I need that listed number and total to default to the last page named totals. I'm not sure really how that page will look yet so I can change the formula to match what I need, but I'm sure it will just be an itemized list of class numbers with the totals.

I really hope that made since please let me know if it didn't.