This is what I would like to do.
We have to fill out this form ... put in customer name, address, etc. ... this will
be the same on all forms.

Then I need to create a report with this info and add details of equipment.... and have
it generate a number for the sheet name like WMR#1, WMR#2....so on for each new sheet
created ... the number sequence will increase.

Is there a way to store static data and then create a new sheet with that data and name
the sheets sequentially!

Hope this makes sense!
I am sure someone already has a similar situation that I could use as a start!

Thank you in advance! Love this site.... at least the info that is here!