How do I add a new worksheet and give it a name by using
code, the name will be entered in cell A1 of sheet 1.

I want a button that I can click that will automatically
create the Worksheet at the end of the book with the name
in cell A1

THanks