Can one Excel cell be linked to different cell depending on what is typed in?

OK, well, I will try explain this best I can. I am a truck driver and I would like to keep track of my fuel, such as what state I fileed up at and how many gallons, so, on a main sheet i got fuel gallons and what state I did it in, so for exmaple when I import 200 gallons and in next columb I import IA for example, on a different sheet it imports the gallons under iowa...I dislike useing 49 sheets, I hacve all 48 states on a summery sheet and colubs with gallons for each week. Take a look at my attachment.