Print button for labels

[SharpTJ]

So I have been fooling with this for a couple days... My goal is to have a "Print" button and the end of that line which will print the selected field on the subsequent worksheets on a label.

I have the main sheet, which when filled out populates a coordinating worksheet.

"Line 1" on the main sheet populates the "Line1" worksheet.
"Line 2" one the main sheet populates the "Line2" worksheet.

The print buttons one the main sheet need to print, preferably single click to the default printer.

I tried to create macro and use VB, but can't seem to get it to work. Can someone point me to the right VB code or a different way to accomplish this?

I tried the mini-sheet add-in but can't get it work for some reason... Here is a link to the file (hopefully it works):

Dropbox - File Deleted - Simplify your life

www.dropbox.com