Copy rows of data based on cell value

I have a spreadsheet with multiple tabs and I want to copy entire rows based on the value of a column - for example I have a column named Account Executive and depending on the name in that column like Rafael I want to copy the entire row that has his name in the account executive column to another tab within the same spreadsheet

Is this possible or do I need to get a database