Hey all,
I am new to excel with little VB experience. I plan on beginning online tutorials soon. I have a vision right now and need advice on how to proceed. To make simple, I work with engineers who need specific forms for certain tests. I have all the test forms in difference excel sheets in one file. I'd like to make a userform that takes in two forms of data.

The first is a checkbox - Suppose "test A" is checked, it will then take that excel sheet and bring it over to a new excel sheet. When multiple tests are needed, they will need a new sheet that is unique with specific sheets.

next is a set of data that is filled out in text boxes that then fill in certain other areas. So if userform asks for client name, they put in the name and it populates that to the header....

This is simple commands but have no clue on how to go about it YET. So please help me out. Thanks all! I'll be a contributor once I learn more!