Copy a row based on a cell value.


I have a very large spread sheet that I am trying to sort on to new tabs. Example tab one has the data and column A is the sorting column that I want to take all the A's out of and put in new tab. I need to copy the complete row if column A meets the criteria. So each tab would have a separate criteria. Can you help?