Hi, I've been trying to get a little pet project running for the past few days, but so far I have not been entirely successful. I have managed to accomplish the desired result by manually performing each step, but I'm here to ask if there is an automatic way to make it all work.

The problem is as follows: A website has four different tables, each on different pages, that I wish to combine into a single table in Excel. Each of these tables is, for what I care about, two columns: date and title. There are more columns, but I don't actually care about them so they can be ignored. I have gotten these pages into Excel simply using the Data->from web tool, to make web queries for each of them onto separate worksheets. Here is my first problem: These tables are behind a login screen, requiring username and password. I can enter those details once, and all of the web queries will update themselves from there, but is there a way to make Excel itself save the username and password?

My second problem is that the tables are not quite consistently formatted. Some of them are just a list of dates and associated titles, but some are of the form:

Sun 01/01/2011 title 1
line of text here
Mon 02/01/2012 title 2
line of text

line of text
Tue 03/01/2013 title 3

etc. The exact number of lines of text and white spaces is variable. I do not care about those lines of text, only about the date and associated title. I have currently sorted this problem by applying a filter, looking for the string "201", as all the dates are from 2011 onwards. This nicely removes all white space and lines of text. However, problem 2: Upon refreshing the web query, the filter is removed completely, requiring me to re-enter the filter conditions and re-apply it. Is there a way to keep the filter in place upon using the web query?

Thirdly, I want these four tables merged into a single one, sorted by date order. Again, this is reasonably easy to do manually from the filtered lists, once I use the "text to columns" tool to break off the 3 letter start of each date (Sun, Mon etc.). Excel didn't want to sort it with these included. Copy-pasting these reduced tables together and pressing sort fixes this problem quite nicely. However, my third problem: This is not an automatic process, it requires a lot of time copy-pasting all the tables to the right places. Is there an automatic way to do this?

A bonus feature would be colour-coding (or some kind of visual identification) each entry based on the table it came from, but that's definitely not required, it would simply be for prettiness sake.

Thanks for reading, and apologies if this is in the wrong place etc.