Print sheets based on filtered results from multiple workbooks

Hi everyone, I'm trying to add another feature to a macro that I have adapted. The base code comes from Ron De Bruin (with the necessary Mods) and works very well for what it is intended to do.
I would like to add a new feature to the code and have little success, in working it out, from numerous searches on the net.

Basically, the code searches workbooks in a folder and returns filtered results for every row that meets the criteria, Copying all those filtered results to a new workbook.

Each of these results has an associated "Detailed List" which contains more detailed information of the actual job.
As the filter pulls a result from a workbook, i would like the associated "Detailed List" to be printed.

The workbooks are all structured the same way:
Sheets that are being filtered are called "CHECKLIST". The checklist contains 17 rows of info (ie. different jobs).
The rest of the work book has sheets numbered 1-17 with more detailed info on each of these jobs.

At the moment I have a Print Button in each row, of the "CHECKLIST" that will print the desired sheet (1-17).

Is there a way, thru VBA, to link the main sheet cells with the respective detail sheet and then print the detail sheet when the "Filter Macro" produces/finds a result?
Maybe the code could activate the associated Print Sheet Macro when a positive result is found by the filter?????

I've attached a sample workbook with the macro code/s in it:


Regards,
Martin