That is really good.

Now ...
What have we learned?

I hope you have learned that when you need to do a macro for a repeated
action, you can record the macro while you do the action manually and then
alter it to suit. That is all I did.

What have I learned?

(1) Perhaps I should teach rather than providing answers. If I had told you
to record the macro you would probably have arrived at a working answer faster
than I did.

(2) I have also learned a lot about the workings of the web  data import
function.