Here's the Code:

Sub filename_cellvalue()
Dim Path As String
Dim filename As String
Path = "C:\Users\lenovo\Documents\Work\Marketing\Invoicing\Qatar\2018\TempFolder\"
Sheets("Global").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, filename:=Range("A46").Value _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False, From:=1, To:=1
Sheets("City Center").Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, filename:=Range("A46").Value _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False, From:=1, To:=1

For some reason, even though I defined a fixed path up top, my two PDF documents keep getting saved to the root "my documents" folder.

The best solution would be some code that could save to the active workbook directory, but I'm not experienced enough to implement that and therefore something that points to a specific directory is the next best thing. I don't want all my documents to get saved to the base my documents folder, though.