How do I input a Flexible URL in Data Scraping

[LVSunsFAN]

I am scraping data for an NBA scores and point spread spreadsheet.
Usually I get it from the website on the day itself, which would be

NBA Basketball Scores - DonBest.com

View NBA Basketball Scores in real-time from top sportsbooks at DonBest the fastest free live betting odds service available.

legacy.donbest.com

But sometimes I have to go back to a previous day, like
NBA Basketball Scores - DonBest.com (not that the 20210313 in the address signifies the date, 2021/03/13)

The code for the scraping part is

    Range("BK3").Select
    With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;https://legacy.donbest.com/nba/scores/", Destination:=Range("$BK$3"))
        .Name = "scores_2"
        .FieldNames = True
        .RowNumbers = False
        .FillAdjacentFormulas = False
        .PreserveFormatting = True
        .RefreshOnFileOpen = False
        .BackgroundQuery = True
        .RefreshStyle = xlInsertDeleteCells
        .SavePassword = False
        .SaveData = True
        .AdjustColumnWidth = True
        .RefreshPeriod = 0
        .WebSelectionType = xlEntirePage
        .WebFormatting = xlWebFormattingNone
        .WebPreFormattedTextToColumns = True
        .WebConsecutiveDelimitersAsOne = True
        .WebSingleBlockTextImport = False
        .WebDisableDateRecognition = False
        .WebDisableRedirections = False
        .Refresh BackgroundQuery:=False
    End With

Is there a way for me to paste the web address into another cell, say BG3, then change that 3rd programming line

 "URL;https://legacy.donbest.com/nba/scores/", Destination:=Range("$BK$3"))

into something that automatically makes the web address whatever cell BG3 says? So

"URL;whatever cell BG3 says", Destination:=Range("$BK$3"))

Thanks!

 

[Domenic]

Try...

"URL;" & Range("BG3").Value, Destination:=Range("$BK$3"))

Hope this helps!

 

[LVSunsFAN]

Try...

"URL;" & Range("BG3").Value, Destination:=Range("$BK$3"))

Hope this helps!

Perfect, exactly what I needed
Thanks, Domenic!

 

[Domenic]

You're very welcome, cheers!