Thanks for your posting and using Aspose.Cells for .NET.
Please see the following article. The article explains how to take pdf of every worksheet. You can modify it as per your needs.
You can hide your undesirable worksheets and then take the pdf of your workbook.