Using information from one worksheet, to rename inserted worksheet
 

I am trying to automate a worksheet as follows :

From a register of information (sheet 1) Insert a new worksheet, move it
into the position immediately right of sheet 1 (making it the 2nd sheet
within the workbook), then rename the sheet using a number in a cell on
Sheet 1.

What I am ultimately trying to achieve is as numbers are added to the list
on the register sheet this information is then used to rename new worksheets
as they are added.

If any one can help I would appreciate it.