Just a general thought:
With the input from your source URL the macro is creating about 1600 variables. So, I think it’s not exaggerated to say that you are misusing KM as a database 
Considering your follow-up post where you are trying to query the data, wouldn’t it be better to export the data to a CSV text file which can be read by Excel for example? Or to a proper database which you can properly query for whatever you need?