Looking for help with a sub to automate this process

Book is set to manual calc

I have a DV list in B3 of say, 5 items (all items are text values),
eg:

Nov06
Dec06
Jan07
Feb07
Mar07

I select the 1st item in the DV: Nov06, press F9 to recalc (this takes
around 1-2 mins). When recalc completes, I copy the entire sheet and do
paste special as values & as formats into a new sheet inserted. I then
rename the new sheet after the item selected, ie as: Nov06.

I would then repeat the process for the next DV item: Dec06,
and continue until all items in the DV list are exhausted.
The book is then saved.

Thanks for insights