I know enough of excel to get around, but I am unfamiliar with data pulls. I would think a script would be able to help me, but I really don't know how to write one.

I'm trying to pull multiple data sets from a site in xml format. Unfortunately, I have to pull one at a time and put them into separate locations on one sheet, which makes it tedious to separate the data and the sheet becomes huge with various tables on it.

Is there a way, I can pull the data from multiple web sites, then it consolidates them unto the same sheet and table, in which I can filter them?

Let's say I want to pull this Data....

1. http://eve-central.com/api/quicklook...limit=10000002
2. http://eve-central.com/api/quicklook...limit=10000052
3. http://eve-central.com/api/quicklook...limit=10000020
4. http://eve-central.com/api/quicklook...limit=10000033

It all goes into one table, which I can then filter and grab the data, then transfer unto another sheet. The data I am pulling, is similiar to a stock market that changes every so often. I am viewing multiple buy and sell contracts for certain items. Which I plan to filter into low sell to compare to high buys for over 24 different items.

I would like to have it pull the data once an hour.

Any suggestions?