Show certain detailed data from other sheet

HI,
I'm seeking help on this pulling data formula.

I want to try two type of method to pull the data from other sheet where the data will be updated monthly.

I have 3 worksheet which named as following:

"Data" - This is the worksheet where will keep on updating data by monthly

"summary by state" - this is where the data will be shown base on the state selection

"summary by all state" - The data will be automatically pull from "Data"

If you take a look at the attached file, you may get what I'm try to explain.

Thanks for help.