Auto Update Rows in One Sheet from Another

Hi All,

I currently have a workbook that has three worksheets (status, issues, risks). I'm trying to find a solution that will take updates to issues and risks (including updated rows, inserted rows and deleted rows) and add/remove them to specified groups in sheet A.

Example: Issues worksheet is a log tracking open and closed items based off of priority. I want to take the items from this worksheet that are open and critical priority and have them added to the status worksheet. As the items are closed they should be removed from the status worksheet.

Same concept applies to risks worksheet.

Does that make sense? Any help is greatly appreciated. I've attached a dummy file as an example.

TJH