selcting and dropping numbers from a list

Hi all,
In Excel
I have a couple of problems that i hope someone can help with. 1/ I have a template worksheet (say worksheet ‘A’where data is entered. At the top of that worksheet I have a cell I would like to have the ‘next available number from a list on a seperate worksheet (say worksheet ‘B’)dropped into everytime the template is opened. 2/ I have also got a ‘save’ button on the template and would like to have the filled out form- worksheet ‘A’saved with the new data entered to seperate worksheets within the workbook with with the tab automatically re-named to the new number. Impossible?