I'm attaching a couple of example docs for this one.
The first doc(URL-Builder.xlsm) shows a list of sample URL's that would be submitted via "data from Web" query using a fictional website
The second doc(Login.xlsm) shows the login script I am using (same fictional site)
Ok. So, as you can see, I have an autogenerated list of URLs/queries that dynamically changes when I change the Initial Date or Interval(Doc1). I have a way to log into the site that these URL's/queries will be submitted too. And I have one example of how to submit
a list of URL's to a website and return data to the spreadsheet. Now, my problem with the example I provided is that this person puts each returned dataset on a separate worksheet. I would like it all on one worksheet in one continuous table if possible. Second, the data that is returned includes headers/titles. My data would also include this information but it takes up two rows for me. I would need to remove that. Maybe that is done with a "cleanup" script after all the data is imported.
**I do not want to put the data on separate worksheets because I could have close to 200 worksheets via the example method all generically named. In addition I would still need to compile the data into single worksheet for it to be usable for my purposes.