Filtered data through formula

Is there any formula by which excel sheet can draw filtered data? For example in attached sheet I've a report sheet where my data updates everyday. In report sheet my data updates everyday. In ICV Truck sheet I need sales person of ICV truck, similarly sales person of MCV Truck in MCV Truck sheet. Name should come only one time. If any new person enters in Report sheet in ICV Truck then that new person should come in ICV Truck Sheet.

Thanks a lot, you have solved my prob in a fantastic way. I'm trying to analyze the formula and will let you know if I don't understand. Thanks again.