I want to be able to have a row of data automatically imported to another
sheet within the workbook based on the criteria of one cell.

Example:
I have a complete project list and each project has a status I want a copy
of the rows data to be input into another sheet based on the €œStatus€� column.
Such as estimating or in progress. Is this possible?? I dont want to have
to manually retype a new sheet based on the status of the project.