"I am ready for the double excel sheet"? I'm not sure what you mean!
All you need to do is double click the product you want to copy the data to its own worksheet.
I do not have the code set to copy data to the next row. It will only copy the data to the same row each time you "Double" click the product.
If you do not want to use the double click method you can have a code that will loop down column "F" and copy the if to it's correct worksheet.
lso you need to formate the worksheets with "Headers" this way you can then have the data go to the next row. As mentioned I have it hard coded to populate each worksheet in row 2 only.