excel automatically generate a number of worksheets

I now have a excel sheet, which is listed A region, based on the possibility of A out of the region automatically generate a number of worksheets, each worksheet areas are named.Do not have to VBA, whether it is possible to achieve? Please give Implementation

have to use macro commands, I will have ready-made, in peacetime, there has been macro command to open the file, and then implemented, will be able to , And very convenient.'s Very clear to tell you to change the structure of the worksheet vba do not have to do is do the wrong
use vb can do is to use a vb write executable file can excel in Vba not have to install and disable the macros being able to use