I have been working on this for a few days now and have had zero luck...

what I am trying to do is create a macro or formula to create and name new work sheet's. I am needing it to reference a number in a cell on the master page of the report and create and name that number of sheet's or tab's.

like if
( A1=5 it would create 5 sheet's named test#1,test#2,test#3,ect... )

and I would like to ad a template to it later but need to get it working first.