Print selected sheets from multiple workbooks

[markspraggins]

I have a series of workbooks all with mutiple sheets. I regularly have to send reports to colleagues which are made up of selected sheets. Is there any way of setting up a routine to print other than creating a new workbook of copies of the sheets I require and then running report manager? Happy to acquire software if that is the option - but what software?

Many thanks