Extract rows to another sheet based on specific words + auto updates

Hi everyone, I have searched and searched google for a solution, but either I was wording my search incorrectly or there isn't a suitable solution posted online yet.

What I would like to do:

I like to keep a track of my expenses/loan payments/interest&principal etc. I have downloaded transaction details from my bank account to excel over a chosen time period. I would like to be able to extract certain rows from the data and have them copied to another worksheet. Pretty much exactly the same function as using the 'Advanced Filter + copy to another location' but it would be great if the function could 'auto update' so that in six months time I could update the data in the list range and in turn all the extracted data on the second sheet would also update without having to go through the whole process of advanced filtering to seperate the different transcations again.

I hope this makes sense?
Have attached a spreadsheet as an example - this is how I would like the data seperated, but if I was to replace the data in the first sheet with that from a different or a longer time period all the extracted fields in the second sheet need to update.

Any help you can provide would be greatly appreciated.
We are still using excel 2002...

V2002 - Seriously? That's got to be a record! I have no idea what works with V2002.