need usf for create pdf & xls separately and sent them in email from multiple sheets

Hello everyone. I am new and Absolute nutshell to VBA and I am new here so please be gentle.

I have one Excel Workbook with many different sheets

i am trying to make a userform that allows me to choose from five of the sheets and and let me to :

1 - creation of separate xls files without macro, without external links and also without specific photos (delete not hide) for each chosen sheet

2 - creation of separate pdf files with all photos for each chosen sheet

3-- creation of separate pdf if it was not done and sent them by email with yahoo not with outlook (email is in TextBox2 = Range("D5"))

I work exclusively from the first sheet "Acceuil"

the sheets concerned contains other photos then specific :

"hanifatoys" - photo = "HHH"

"Aternal" - photo = "AAA"

"Arba" - photo = "BBB"

"FINALE" - photo = "FFF" planned not yet made

"BL" - photo = "LLL" planned not yet made



sPath = ThisWorkbook.Path & "\2021\" & ActiveSheet.Range("D4") & Format(Range("D6"), "-dd" & "-mmmm" & "-yyyy-") & Format(ActiveSheet.Range("D7"), "000") & "\"



thanks in advance

nb: cross link at ozgrid since one day no solution proposed yet
It's not that I'm in a hurry to find the solution but I have been racking my brains for weeks trying to find the solution with my modest knowledge unfortunately nothing at all