Display results of slicer in new worksheet

[m1ngle]

I'm working for a construction company which bids on jobs nationwide. I have a spreadsheet with several slicers. This allows data to be restricted, of course. What I'm looking for is any way the results of this filtering can be displayed in a new worksheet. So, If I select jobs in California, in the Central Valley, which were bid for over $5M, is there a way to dynamically show the jobs which are in this list? Thank you, I hope this makes sense. I am using Excel 2010.

 

[thebaumbaby]

Are you looking to aggregate the data in one total, or list each item line by line?

 

[m1ngle]

Hello;

I'm looking to list each item line by line.