Extract data from Pivot Table

Hi All,

This is probably a relatively simple macro to program but I have extremely limited experience with coding so any help is welcome.

What I am trying to do is pull a series of specific rows from a pivot table into separate "reports"Example.xls. Reference the affixed Excel workbook under the worksheet 'Pivot Table'. I want to pull each of the different product names (Consults, MLPA, PIA, etc.) and the associated rows into a separate report. I would use the grouping function but, as you can tell, several of the rows include multiple products.

Is there a way to pull out the rows for each of the products? I've included an example of a report I created manually by selecting the rows in the product filter drop-down.

I also am looking to create a report that summarizes the product count (number of MF for example), the product frequency (how many times did MF show up in September) and message type count (number of Business Messaing for example).

Again, I have no idea how to even approach this considering the lack of VBA knowledge but any help is very much appreciated.

Example.xls