print using worksheet name from excel macro

[netpilot]

First post.
I have a 3 sheet Excel spreadsheet and would like to print each worksheet to a separate pdf file from within a macro, using the worksheet name as the pdf output file name in each case i.e. sheet1.pdf, sheet2.pdf, sheet3.pdf. Thanks for any ideas, as I've failed with everything I've tried so far.