How to make a selected value in a data validation start a different macro everytime a different value is selected

[ajgolfs]

Let me try to explain what I'm trying to do. I have data that are separted into different years. FY10,FY11,FY12,FY13. Each year of data is a named range (FY10,FY11,FY12,FY13). I have a column that has a data validation that allows you to pick each year. I'm trying to find a way that when you click on the data validation, and select a different year, have VBA cut and paste the row at the top of the FY named range selected. For example. If one of the rows was under FY10 and I clicked on the cell with the data validation and changed it to FY11, have VBA cut the row and paste it at the top of the FY11 range. And also be able to do that for FY11,FY12, and FY13. I need it to move the row everytime you change the data validation year. Please help.

Thanks,

AJ