Name exported file

Hello everyone, I should create a macro that exports my table in PDF but I would like the exported file to take the name of the sheet and not the part … does anyone know how this can be done?
Thank you

One exemple please for this pdf

I created a macro that automatically exports me the drawing .pdf and creates a file with the name of the part … but I would like that when the macro creates the pdf file, the file name is that of the sheet … … the one at the bottom left under the drawing.