Welcome to the forum.
The fact that it always names the second sheet "Sheet2" is a normal SW function.
To get what you are trying to do, your best bet is to either create a macro routine (written code)
or find one.
Here are a couple of links that might provide you with this.
Yes, that can be done. Check your codes for "Sheet 2" and change it to what ever you need.
In case you don't want to mess, please share your codes here and someone will fix that.
Please use "advanced editor" in case you want to attach any files.
You might also find this post helpful for your future reference.