Macro (?) for importing a range of patient data and printing pages for each patient

Good day,

This is my first post on this forum. My name is Gasen, and I currently work at a clinical pathology lab in Japan, with a large portion of my work involving the processing of data accompanying our patients' physical tissue samples. You have an excellent forum here, and I hope to learn much from you all.

With that said, please allow me to move on to my question. At the lab, patients' records and tissue specimens arrive from hospitals, with the records being input to our intranet database. After entry, said records are 'printed'/exported into an Excel table, with eight patients populating each Excel file. These tables are then printed into hard copies, hand-checked, and submitted to the hospitals along with the specimens after we are finished with them. This step is seamless enough, but the next has proven to be quite tedious.

In addition to the eight-patient tables, a blank table for each individual patient (containing only the patient number, name, and date of processing) must also be printed (from a template), filled out by hand (unavoidable, as this is done simultaneous with examining specimens under a microscope), and sent to the hospitals. This is fine enough, but the problem lies in the fact that the patient names and numbers must be written out by hand on the printed template, along with processing date (which cannot be helped, as the date often changes at the last minute, long after the papers have already been printed). What can be helped is the writing-out of the patient name and number by hand, as this data already exists in the aforementioned eight-patient Excel tables.

While it may seem to be a minor detail, as we could be filling dozens of these each day, this amounts to a couple of work hours a week. Being able to cut these is an obvious choice. What I wish to do is populate the individual blank template patient tables with two fields of data from the existing eight-patient tables and, ideally (as the individual tables need not be saved), do so directly to the printer.

I apologise for any ambiguity in the request. Please let me know, should you require further details. Thank you in advance.

Kind regards,

Gasen