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).

[TABLE="width: 212"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]CaseNumber[/TD]
[TD]WorkState[/TD]
[TD]Location[/TD]
[/TR]
[TR]
[TD="align: right"]10800[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD="align: right"]10802[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD="align: right"]1003[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD="align: right"]155646[/TD]
[TD][/TD]
[TD]ABC[/TD]
[/TR]
[TR]
[TD="align: right"]54640[/TD]
[TD][/TD]
[TD]BED[/TD]
[/TR]
[TR]
[TD="align: right"]54564[/TD]
[TD][/TD]
[TD]BED[/TD]
[/TR]
[TR]
[TD="align: right"]246564[/TD]
[TD][/TD]
[TD]BED[/TD]
[/TR]
[TR]
[TD="align: right"]2782[/TD]
[TD][/TD]
[TD]BBD[/TD]
[/TR]
[TR]
[TD="align: right"]564564[/TD]
[TD][/TD]
[TD]BBD[/TD]
[/TR]
[TR]
[TD="align: right"]123[/TD]
[TD][/TD]
[TD]COB[/TD]
[/TR]
[TR]
[TD="align: right"]564[/TD]
[TD][/TD]
[TD]COB[/TD]
[/TR]
[TR]
[TD="align: right"]987[/TD]
[TD][/TD]
[TD]COP[/TD]
[/TR]
[TR]
[TD="align: right"]2357[/TD]
[TD][/TD]
[TD]COP[/TD]
[/TR]
[TR]
[TD="align: right"]56871[/TD]
[TD][/TD]
[TD]DAD[/TD]
[/TR]
[TR]
[TD="align: right"]5967[/TD]
[TD][/TD]
[TD]DAD[/TD]
[/TR]
[TR]
[TD="align: right"]6891[/TD]
[TD][/TD]
[TD]DED[/TD]
[/TR]
[TR]
[TD="align: right"]365981[/TD]
[TD][/TD]
[TD]DED[/TD]
[/TR]
[TR]
[TD="align: right"]5657[/TD]
[TD][/TD]
[TD]FAR[/TD]
[/TR]
[TR]
[TD="align: right"]548[/TD]
[TD][/TD]
[TD]FAR[/TD]
[/TR]
</tbody>[/TABLE]

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.