saving files automatically in excel

hi

(1)
i have one excel workbook about attendance details and it has two shifts (A &B) every day it has to be saved under the respective date inside the respective month (example Shift A Absents 26-11-2011, inside folder named November inside folder 2011 so it has to be c:\2011\November\Shift A absents 26-11-2011.xls) im new to Vb coding and macros, so please advice how to do it.

also

(2)
i have one sheet in the same workbook where i enter the absent employees and check how many days there are absent i did that using vlookup i want to save only this worksheet differently inside a specefic folder and with the respective date as mentioned above (a shift ab, b shift as)

(3)
there is a worksheet containing all the summery in it i have to mail it end of every month is there a code to do that so..