Help with "save as" macro

[dwarner]

I need to create a macro that allows me to save from a template with new information entered, into another workbook, as a new worksheet, with the tab named after one of the cell contents in the template. The cell I want to name the new worksheet will be a job # such as 11TR006, entered into cell B1.

I want the user to be able to click the button in the template, and have this save function happen.

I have no experience with this or with VBA, but can follow instructions pretty well if someone can write the code for me. I would really appreciate the help.

Thanks!
D