ActiveX Label Caption equal to activecell on different sheet

I have a database full of products with product information. I am looking to create a separate sheet to use as a plot template per product. I am trying to use activeX labels to look at the database cells to retrieve product name, part #, etc. At that point I can assign a button to print current or print all. I created a userform to move the current cell down, at that point it populates the userform with all of the activecell product information. This is setup as a product viewer. On that same userform is where I want to add the print current and print all buttons. I looked into using userform.print with a separate userform but I did not like how it was printing.

I am using:
Label1.Caption = ActiveCell.Offset(, 1).Value

It works great in the plot template sheet. I thought it would behave different. When I run the print code it makes the plot template sheet active.

Is there a way to have the labels pull the active information in the viewer?
OR
Is there a different way to go about this?

Thanks,
Mitch

Thinking about it..... I could tell it to copy template sheet, then copy the info to the copied sheet, plot, then delete.

I was hoping to have the template "real time".

Does anyone know if this can be done?

Thanks