Data sort issue

[Maggie]

I have two worksheets, one that has data and the other is a summary of
the data. In one column have states and I want the summary sheet to
give me the top five states and their percentages. This data changes
all the time so I cannot do a simple data sort. Please help.

Thanks,
Maggie