auto fill cells based on value entered in first cell?

Hi
I am tryign to make a "form" where
Users enter (select) data (from a list) in one cell that results in other data (from a list) appearing in a different cell.

For example,
How would I have "2007-2008" auto fill in one cell (indicating previous year) after the user selects the 2008-2009 in a previous cell?

I attached one sheet (the question sheet) or a workbook I am trying to create that is basically a form that a user fills out that produces a report for them based on entered data.

Thanks for any help you can offer.
Synthia