I manage 3 sales reps. I use 3 separate spreadsheets to list all the prospects for each rep I will call and make appointments for. I am adding more and more tabs as i go and can't manage the extensiveness. Is there a way to consolidate them and have one sheet that I can update each category? In other words a spreadsheet that has multiple sorting capabilities on a single sheet? LOCATION: Caifornia Nevada Washington Category: Prospects Follow ups New Clients Users: M. Smith B. Jones R. Williams ALL