Reading/Parsing RSS Feed.

Okay so I’m trying to do something a little ambitious here. Essentially I have a sheet that currently does what is shown in the attached jpeg

Now currently what I have to do is when something is released I must type the number released into the category for the sheet to update the missing number. (The missing checks if there is something in missing before subtracting btw)

Now I have an RSS feed from a website where I find out if something is released. I’ve looked up ways to retrieve an rss feed, and ways to use search to check if the title, category, filetype, and release number match what should be in the sheet. Though none of this has worked fully, and I’m looking for some help. Now the rss retrieves things in a form similar to this (this is for anime and tv shows)

[Small] Junk Data – 06 (1280x720) [sfadsfh].mkv

The problem with this is that not all of the titles are in this format, they all have the category in front followed by the title and then release number followed by some crap and then filetype. Sometimes there are spaces and sometimes there are underscores, sometimes there are dashes and what not, and the data following the episode number may be just the crc # or a long line of crap. In short the data from the feed isn’t easily searchable.

Also the annoying thing about this is what the current rss import does is keep a set number of cells filled with the title data and when the sheet is open and I refresh the data it overwrites the old with the new. This too is not ideal, and having it append data means it repeats the data that was already in there automatically, and any change to this with validation just makes it ugly.

So is there a way I can have this excel sheet import an rss feed and update it with “all” entries that it’s missed within last update, then search through this data to find the category, filetype, title and if the release number is higher than the download number and if true place the release number in the correct cell?