I've been reading previous posts, not found what I need and am worried about
a new task I've been assigned. I need to prompt a user for a worksheet name
after the user clicks on a button and when the name is entered, it will be
entered on the sheet tab, in cell A1 of that worksheet and into a cell on a
summary sheet located in another part of the workbook.

I have no idea where to start and I'm not a programmer.

All help is desperately needed!
Ninner