Create a individual sheet in Excel...

Hi All,



I have an excel sheet contains some data with drop down option.
So my request is here I need a macro when I click the “Generate” button each and every drop down list can be generating an individual excel sheet and stored the same location stating the name of drop down selection (Eg: Please refer the Result sheet – CTS). Hope this helps.


Thanks/Raju