SO i have MAster Excel sheet wher the below data is there enter image description here
Now i want VBA script which will take the Green colour as the SHeet name create a sheet based on the name. Now from teh master sheet based n the tab name copy the row of that cloumn and the header. This is more like i have to give he Cell values and copy the header and partiicular row of that cell value matches the Sheet name