Get list of sheets through macro

[#1]

Can i retrieve a list of sheets using macro and print them in to only one pdf file?

[giakoum]

Why not create a report?

[#3]

Because the end user (that's not me) asked not to want to use the "Report" tool, but choose the list of sheets to be printed in a single pdf file via a menu.