Grouping Sheets and converting to PDF based on criteria

hi there

i am hoping some can help me. I have a spreadsheet that has multiple sheets in it and I created a summary table to show the sheet names and specific cells from each sheet. in the summary sheet i have grouped some sheets together, which i would want to produce a PDF document of all the sheets per Grouping

Sheet # Name Date Grouping
Sheet1 Name1 Date Group1
Sheet2 Name2 Date Group1
Sheet3 Name3 Date Group2
Sheet4 Name4 Date Group3
Sheet5 Name5 Date Group1
Sheet6 Name6 Date Group1
Sheet7 Name7 Date Group2
Sheet8 Name8 Date Group2
Sheet9 Name9 Date Group1

so i expect to see 3 PDF documents, first document for Group 1 to include Sheet1, Shee2, Sheet5,Sheet6 and Sheet9. Another document for Group2, to have Sheets 3,7 and 8. And the last one is for Group 3 for Sheet 4.

I would also like to specify the where location of the files to be saved, and have them saved as per the Grouping name

Thank you all in advance

H