Using Excel 2003, I need to do the following:

So essentially I have the status column with a drop down that contains, Construction Complete, Ready For Install, and Complete. What I want to happen is when the status is changed to:

Complete: The whole row will transfer/copy to the corresponding tabbed sheet based on Division which is a cell within the column.
Construction Complete: The whole row will transfer/copy to the Construction Complete tab.
Ready for Install: The whole row will transfer/copy to the Ready For Install tab.

As a further note, I need this functionality on all tabs for the status.

Any help would be greatly appreciated.