Move Data Between Worksheets

I keep an on-going list of open and closed accounts. Usually the spreadsheet will look like this:

_____________________________________________________
|Account 1 | Account # | Account Name | Date Opened | Open
|Account 2 | Account # | Account Name | Date Opened | Open
|Account 3 | Account # | Account Name | Date Opened | Closed
|Account 4 | Account # | Account Name | Date Opened | Open
|Account 5 | Account # | Account Name | Date Opened | Closed


I have two other worksheets - one titled "Opened" and one titled "Closed"
How do I tell excel to have these accounts show up in the respective worksheets after I every time I write "Open" or "Close' in that last column on the first worksheet?


Basically, I want each of these accounts "CC'd" (for a lack of better terms) to either the "Opened" or "Closed" worksheets as updated.

Moreover, I want them to disappear if one is changed.


Thanks for the help