There is a button on the page that allows you to download a csv file. The URL it uses is:

https://query1.finance.yahoo.com/v7/finance/download/AMAT?period1=1680858276&period2=1712480676&interval=1d&events=history&inclu deAdjustedClose=true

You can use the code you have but instead use this URL and replace the /AMAT? with each of the ones you want downloaded, if you're running this in 64-bit Office add PrtSafe to the declaration of the function to download the file. 
Private Declare PtrSafe Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long


This simple code snippet downloaded the first in your list
    Dim downloadURL As String
    downloadURL = "https://query1.finance.yahoo.com/v7/finance/download/AMAT?period1=1680858276&period2=1712480676&interval=1d&events=history&includeAdjustedClose=true"
   Dim ret As Variant
    ret = URLDownloadToFile(0, downloadURL, "F:\temp\test.csv", 0, 0)