And which application would you be using to create the PDF files?
I have had success with the free file downloads and instructions for use
here at Dale Nurden's site.
http://www.rcis.co.za/dale/info/pdfguide.htm
Saves first to single *.ps file which is then converted to *.pdf
Returns one PDF file from multiple sheets.
See also David McRitchie's site for alternatives to the above.
http://www.mvps.org/dmcritchie/excel/pdf.htm
Others have reported that PrimoPDF does a good job and is free.
Gord Dibben MS Excel MVP