I am using Adobe PDF maker 6.0 in Excel 2002 SP3

I would like to create individual PDF's per tab in a workbook using the tab
name as the file name. Excel would prompt me for the Path, and then use the
tab name as the file name. Any ideas?