Adding a column from the source file name – The file is sourced via a URL

Hi John,

Thanks again for your help.

In regards to the original location from which I grabbed the URLs, I have just got them from the website itself. Ideally there would be a contents list of target files and locations available but of course this is not the set up. Instead the URLs are located within different pages on the website.

To some degree though, I think I have been coming at my issue from the wrong direction and therefore over complicating things. I am simply looking to grab a number of years (each year has a different file) of data, tag them by their respective year (i.e. column for Year) and then append them into a single table.  In doing this I was trying to view the website as a folder structure, with designated folders and contents such as files. This is obviously not correct. 

As such I have changed my approach, now focusing on the URLs by implementing them using parameters which allows me to update the target URL as needs whilst at the same time passing the parameter value to the table within a column. 

So I think I am good for now. I again say thanks and apologies for giving you a runaround!

KM