Macro to select worksheet based on cell value and then return data to diff worksheet

I'm new to VBA and would like to run a macro that selects the corresponding worksheet based on a cell value and then returns data within that worksheet to a "summary" worksheet.

I have attached the spreadsheet. So if the year is 2012, i want to select the 2012 tab, then return the schedule that corresponds to Alabama for the 2012 year. I might be making this harder than it needs to be but I dont want to have to write long ifstatements.

Thanks

See if this helps...

CFB Predictor - ASRev.xlsm

How do i edit the macro to select the corresponding sheet when the cell value changes? Like if the year is set to 2011, I want to select the sheet named 2011, if the year is 2013, select the sheet named 2013. But then select the same data on each sheet since its in the same cell.

I have attached the spreadsheet. When i change the team it doesnt automatically change. I have to retype in the year for it to change. Ideally like the schedule to update automatically when i change the year and when i change the team

Thanks for the help!