XML / VBA / MS EXCEL

I need a script created that will:

1. go through all links (they point to xml files) (this will be a loop as number of links will change from time to time)
2. from each xml file, get the specified child node data and paste them into the excel file


The xml file will look like this

<response>
<link type="text/css" rel="stylesheet" id="dark-mode-custom-link"/>
<link type="text/css" rel="stylesheet" id="dark-mode-general-link"/>
<style lang="en" type="text/css" id="dark-mode-custom-style"/>
<style lang="en" type="text/css" id="dark-mode-native-style"/>
<dataset>
<id type="integer">11812943</id>
<dataset-code>ZZZZZZZZZZZ</dataset-code>
<database-code>ZZZZZZZZZZZ</database-code>
<name>ZZZZZZZZZZZ</name>
<description>ZZZZZZZZZZZ</description>
<refreshed-at type="dateTime">2021-10-08T16:01:16Z</refreshed-at>
<newest-available-date type="date">2021-09-01</newest-available-date>
<oldest-available-date type="date">1948-01-01</oldest-available-date>
<column-names type="array">
<column-name>Date</column-name>
<column-name>ZZZ</column-name>
</column-names>
<frequency>monthly</frequency>
<type>Time Series</type>
<premium type="boolean">false</premium>
<limit nil="true"/>
<transform nil="true"/>
<column-index nil="true"/>
<start-date type="date">1948-01-01</start-date>
<end-date type="date">2021-09-01</end-date>
<data type="array">
<datum type="array">
<datum type="date">2021-09-01</datum>
<datum type="float">61.1</datum>
</datum>
<datum type="array">
<datum type="date">2021-08-01</datum>
<datum type="float">59.9</datum>
</datum>
<datum type="array">
<datum type="date">2021-07-01</datum>
<datum type="float">59.5</datum>
</datum>

FROM THIS ONLY DATE AND VALUE NEEDS TO BE TAKEN OUT AND INTO EXCEL.

WE MAY NEED FEW MINOR VARIATIONS DONE AS THE NUMBER OF CHILD NODES MAY VARY.