Creating New Worksheets based on a list of names

Hi,

I am trying to
1)create multiple worksheets based on a names from a the worksheet "Names".

2)The source of the copying is from the work named "Copysource".

3) In addition, I want the worksheet names of the sheet to be based on the Names sheet and also for every of the new worksheet cells(1,2) to have the worksheet name also

here is the code i have so far

Please Login or Register  to view this content.

thanks for anyone helping in advance

Mod. edit: CODE rather than QUOTE tags please