print the invoice

[leoruphen]

Hi all,
I would like to use a command button for printing invoice, but i want when i press the print button i want the invoice number to update automatically,
and i want some information from another sheet to be displayed on the invoice once i clicked the print button.


I have attached the sample picture for reference.