I have a spreadsheet that is used to track status (progress) of certain jobs. I would like to be able to update the original sheet and as the status' change per project the data (row) will still be present on the original sheet but will also automatically be copied over into another sheet. I dont know if I would have to have a seperate sheet for each status criteria to copy to or if I could have the data copy over to a single sheet that would then be automatically be sorted or filtered by that certain status? Is this possible?

Thanks
Misty