macro to save excel shees

Hi
I need a macro to save few excel sheet.
My macro should work like –
It should open a new excel workbook and then copy “final sheet” contents in from sheet “For saving sheet” and then paste the same in new excel workbook and come to the sheet2 of new workbook "A1" cell and then save the file with the same as mentioned in "Column D" from excel file” “For saving sheet” . "example-"AR 1001-AP 1008 dtd 12042012".Like wise it should create different files as per contents mentioned in "Colum D" . for example for attached particular sheet when macro is running it should create 11 excel files. Is it possible?
Please find the attachment for reference.
Thanks and regards
Shradha