Can I combine selected excel worksheets, from multiple workbooks, into one pdf...?

[NZTC70]

Hi all,

I'd like to combine selected excel worksheets from multiple workbooks into one pdf. 

Eg, I have 10 workbooks, saved in different folders.  Each workbook has several worksheets.  I want to be able to select 1-3 specific worksheets from each workbook and combine them into one pdf.   Does such a tool exist or am I asking too much?!   In the absence of an existing tool does anyone know how I might achieve this?

Thanks in advance..

[~graffiti · Accepted solution]

With the full version of Acrobat, you can print those worksheets to pdf's then combine them. Not with the free Reader though (which is the focus of this forum).