how to call for printer function

I have a printer, and finally figured out that it changes on the name, so its named like this:

Canon on NE01:
Canon on NE02:
Canon on NE04:
Canon on NE05:
and so forth
after searching it came up to something that works on dynamic names of printers from this link: https://www.excelforum.com/excel-pro...numbering.html

If someone that can help me write the sub to print on whatever the printer name is to print the below sheets:

Sheet4.PrintOut

i dont know how to call for functions, and just started reading about functions, unsure how to use it yet. If someone would kindly moc up a simple example of this please
Arkadi in post #30 on that link, if someone that can merged it to print out sheet4 please