Is it possible to export your workbook into seperate files based on each worksheet and name them according to worksheet name? Adobe automatically does this for you. Someone told me I would need a macro to do it.

Any thoughts?