Creating new worksheets from given list

I have got a worksheet wherein Column A contains the Customer Code, & Column B contains the Customer name. I want to create new worksheets based on the Customer Codes in Column A i.e for each Customer Code, new worksheet should be created wherein I would later on enter some formatting & data in the worksheets.
When I select Delete worksheets, all the work sheets other than the 1st worksheet should be deleted.

Thanking in advance for all the help !!

Here are two routines which you can assign to your buttons

Please Login or Register  to view this content.

The above is setup such that if a sheet exists it won't try and add it again.

Please Login or Register  to view this content.