Help with creating and populating sheets from a register/spreadsheet

I was wondering if anyone can help me with this.

I have a register that I have made and want it to generate a data sheet from the information that is populated into the register. Basically just to generate a pre populated form so you dont have to fill in the information twice.
I want the button to generate the CIO or CAN based on the Row that is being populated at the time and also the type of file from the C column. Basically it has to descriminate so that it wont create a CIO when the field populated is a CAN and vice versa.
Is there anyone that can help? I have no VB experience but have managed to put this much together so far.

Thanks for your help on this. It has been really frustrating but I am slowly getting there and i just need some assistance with the last few parts.

Newguy