The Google Sheets Filter function is a great function for extracting data from one source and displaying the data on another sheet. The one thing to remember about the Filter Function is that it must filter. It can't return all of the data, or not that I know of. So that being the case you can use the Query Function in conjunction with the Filter Function to get a pretty cool filter interface dashboard type sheet.
Try the following:
BTW: You can use this Spreadsheet, remember to upload it to Google Sheets first.
You can follow the above tutorial to pick up a few handy guidelines as to how you might use this function to create a sort of custom filter dashboard.
Remember to check out our Google Sheets Q & A for extra tips on functions.
