[Excel] - Copy Value and Save As Macro


I'm trying to write a macro to copy a single value (ID number) from column C in a table on Sheet1 into cell A2 in Sheet2, and save a copy of Sheet2 as a new workbook titled as the copied value (ID number). It then needs to copy the next ID number down in column C to the worksheet and repeat for the length of the column so I end up with a series of saved files titled as each ID number in column C in the original workbook. Can anyone help me?

Many thanks, Harriet.