|Not only is your question unclear, but you have not provided enough details for us to offer a solution.|
re: "I want that when I enter detail in sales sheet the Invoice will automatic generate in new Sheet Or Automatically create new excel sheet "
What's the difference between " the Invoice will automatic generate in new Sheet" and "Automatically create new excel sheet"?
As far as details, since we don't know how you use your workbook or what action should trigger the creation of the new sheet, there is not much that we can offer at this point.
You need to provide more detail.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.