VBA to copy sheet, move to end and rename to next number in sequence

Hello!

I'm fairly new to VBA so any help would be much appreciated.

I have a worksheet and I want to put a button at the bottom that says 'add next date.' When clicked, I'd like it to copy the sheet and move it to the end and rename it to the next number (date) in the sequence. For example, the first sheet is called '1' and when the button on it is clicked it will duplicate it and rename it '2.'

Please can anyone help me with this or point me in the right direction of some tutorials that might help?

Thank you!

That's perfect! Thank you so much!

JLG.
Not knocking your code but it fails if you would have a sequence of for instance "Master Sheet", "2", "3" and start copying sheets from there.