vba search for value in column, return corresponding cells in same row

Hi,

I have a vba problem which seems straight forward but I can't figure out how to do it. Basically I'm trying to set up an excel file whereby a user will select their state via a dropdown. I need a macro that will then search in my raw data for the state they input and return the corresponding value(s). The state is found in column A and I'd then like to return the corresponding values from columns B and C. There will multiple values in Column A hence the reason I can't use vlookups. I'll be updating the raw data tab on a regular basis so would like to summarise it on the 'Summary' tab. The actual dataset is a lot bigger than this so I want to be able to break out down by state as this is what the end users will be interested in. I've attached the mockup data. Any help would be greatly appreciated.

Cheers

try it (see attachment)

Thanks nilem, worked perfectly. Are you able to explain how it works?