Trying to copy master data sheet rows if criteria exists to a new sheet

Hello,
I got left with this spread sheet at work where we log all our jobs. I am trying to make a sheet for each salesman to follow up with jobs we quoted. I have all there names listed and will fill in if they're custmer is quoting the job i want it to populate a new new sheet for that specofic salesman the list is always being added to so it would have to be open ended. I am very novice when it comes to excel can some one please help. Attaching a sample of the spreadsheet. Basicaly each row is a job,want to key off column AN-AY if it is populated and have the entire row copied to the corresponding salesmans follow up sheet if there column is populated.11-13-13.xls