userform for printing

Hello everyone,

I have only just started playing with the advanced functions of excel and I am truly amazed, my eyes have been opened. I have limited programming skills but I have learnt a fair bit from reading other posts on here and have worked out a bit by myself, but I need help now.

Im creating a sheet for some tests that I have to do at work, trying to get them organised and recorded, I could make it basic, but im loving playing with all the advanced stuff and I want to learn more, so I thought this is a good starting place.

The book is going to have a sheet for every object to be tested and the data will be manually entered into thoes sheets, there will be a sheet at front that will act as a contents page with links to the sheets so its easy to naviagate. I also want the front sheet to have a print button that opens a userfrom that has checkboxes to print witch ever sheets you want in that section.

I was wondering if there was an easy way to copy the sheets and name them acording to the data on the contents page, instead of manually copying then renaming? Im hoping to have just two sheets as templates, one for contactors and the other for motors.

The other problem I am having is creating the userforms for printing, is there a way to have them populated with check boxes or some other way of selecting sheets automatically acording to the data in the group, or would I have to do them manually as well?

Thanks in advance.