Unsure Macro or Pivot??

[XLSHOPER]

Hello, this great, I am so lost.. I have the following inquiry... I have rather large report that I need to glean data from each morning.
Below is a sample.

What I would like to do is.. run a macro every morning that automatically selects certain locations from the report and creates a new sheet with only designated locations...

For instance, I would the pivot/macro/vlook(?) to create a new tab/sheet that only displays the rows of data for the locations of BED, COP, DAD and FAR.. (the daily report has about 2k rows of data and approximate 22 columns, the search or end report will should include 26 or so locations).

CaseNumber	WorkState	Location
10800		ABC
10802		ABC
1003		ABC
155646		ABC
54640		BED
54564		BED
246564		BED
2782		BBD
564564		BBD
123		COB
564		COB
987		COP
2357		COP
56871		DAD
5967		DAD
6891		DED
365981		DED
5657		FAR
548		FAR

<colgroup><col><col><col></colgroup><tbody>
</tbody>

Any Help or guidance is greatly appreciated! I exhausted my limited knowledge and push every button on the menu.

ty!

 

[mole999]

if its the same sheet I would name the data (or bigger) as a range then create a quick pivot from the named range

 

[XLSHOPER]

Um, I am a complete novice... what are you sharing? please indicate the menu tab (file, insert, etc..) associated with the recommended action.