Isolating specific text and numerical values in an excel database

Is there a way to search a spreadsheet (updates weekly) and return a particular value and all sub values for that value? For example there is a "location name" column header. Within each location there is a varying amount of rows listing items located at the location. I want to be able to pull a one location and ALL the products associated with this location on to a separate sheet. I "location" will have 5-45 sub-items. Can this be done? Hope this makes sense?