Importing multiple XML queries into Excel
 

I am trying to import multiple XML queries into Excel and cannot import more
than one at a time.

I have a list of queries and am using the XML feature to pull the data.
Unfortunately, I have to cut and paste each query and then import them
individually.

Does anyone know how to automate this process or if there is an easier way
to import batches?
--
Thank you in advance for the help. I need it!