Copy Values only from Raw data

hi Guys,

I am not a master of excel but can anyone here can do a formula or a code to copy only the values that i want from Raw Data tab to Summary Tab.

on the Raw data tab i have got the exported data that are really not good in sense on their alignment and some of the agents don't have evaluation score and i only need to copy those agents that have evaluation scores and date to SUmmary Tab.

Please can anyone here show me how to do this..

Thanks.

Please see attached file