macro to save specific sheet as pdf direct to folder linked via cell

hi guys

i would like to be able to save a specific sheet direct to a folder depending on what is in cell a2

if i hit the macro button i want it to do the following
save sheet "specifics" to a folder based on whats in cell a2

ie to explain

i have a job file destination as - \\myserver\job_file

it then needs to look up the folder with whats in a2

so if a2 has J7777 it would then look up J7777 in \\myserver\job_file
it would then locate subfolder within that folder called contracts and place that in there as a pdf

is this possible?
I look forward to any help.
i have to be honest and read some of ron de bruins stuff but cannot get my head round it enough to make this work.
regards

hi dom

thank you for your reply.
really appreciated.
oddly enough it worked the first time and i saved if first but now it doesnt and it doesnt come up with an error.

what i should have said is that whilst it would look up the job folder
in the example we used ie J7777 it would then have the client name

so the folder name would be something like J7777 - Smith
this would affect im sure?
regards

within that job folder J7777 - Smith are several sub folders.
i need it to locate the contracts folder in that and place said pdf in there

surely you mean a2?

bizarre cant get it to work now

hi dom ive got it working again but not correctly.

the original workbook is here > \\myserver\contract office documents\STEVES DOCUMENTS\THE NEW JOB FOLDER

i have the following code in my macro button

Sub Button10_Click()
'
Dim strFileName As String
strFileName = "\\myserver\job_file\" & Range("a2") & "\contracts\"
Sheets("PARKING AND ACCESS").ExportAsFixedFormat Type:=xlTypePDF, Filename:=FName, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=OpenPDFAfterPublish
End Sub

but oddly enough it saves it back here \\myserver\contract office documents\STEVES DOCUMENTS\THE NEW JOB FOLDER

bump bump bump can anyone help please?

please can anyone expert help with this