Transfering Data from worksheets by date

Good Evening all

I have a series of worksheets that are names all the same eg 2011 Data 2010 Data 2009 Data 2008, etc etc etc and are all identical in structure.

I use a macro to transfer the data from the eg 2011 Data across to the Winners worksheet, is there anyway that some code by placing the year ( eg 2008 ), in a cell in the Winners sheet, and the macro code transfer from from the respective DATA sheet into the winners sheet into the respective cells.

Attached is the Very much cutdown . XLSM file with some the macro's that I use.

PLEASE IGNORE the macro's as they are linked to sheets that have been removed, to leesen the file size


I ONLY NEED the data shaded in PINK to be transfered from Data named sheets to the winners sheet.

Regards

Peter