Hey Seq,
if you send me the excel doc and tell me what you want i might be able to set it up for you.
Judging by your comments you are correct in thinking what you want cant be done in one tab but in excel you can create new tabs and even create formulas that make totals based off information from other tabs.
Let me know if you want to take me up on the offer.
or create a new tab and see if that opens it up for you to do it. look up in the help files Creating new Tab.