Macro PDF Save from Excel

[JFORTH97]

Hi

I'm trying to create a Macro so from my worksheet by pressing a button it will export it as a PDF but then save it based on 3 cell values C4, C6, C8 (All Values are Text)

I'm wanting to save it to a specific file location smb://seacroft_file/Head Office Management/Timesheets

Its Excel For Mac V16.47

Can anyone help me? Thanks