Using VBA to Repeatedly Copy Cells Updated via Drop Down List

Hi,

In the attached workbook i have a drop down list of locations in cell C2, with cells C9:L13 updating according to the selection. I am looking to assign a macro to button 6 that will select each of the available items from the drop down list, copy cells C9:L13 and paste the values onto a new worksheet named as per the current date.
I'm OK with the inserting of a new worksheet initially but then I can't work out how to name it by effectively using the =TODAY() formula. Similarly I can copy the relevant cells and paste their values onto a new sheet but I can't force it to do it for each item in the list sequentially, I thought it might be something like 'for each item in list' but i'm not sure.

Any help would be much appreciated.

Cheers
Stu