Extract Data from Pivot Table with VBA

I have a Pivot Table (Pivot_Table_Report) on a sheet called "Summary" with a several fields (Name, Month, Area). I would like to be able to extract the data from the pivot table based on certain conditions for the fields given by the user in an input box and export it to a new workbook. For example, on the pivot table if you look at John for the name, July for the month, and North for the area it gives a total of 10. The user can then click a button and enter those same values into input boxes and get the data that makes up the 10 in a new workbook.
I have looked all over and can't find a formula to use that incorporates more than one field. Any assistance would be appreciated! Thanks.

Thanks for the quick reply. I would like to prevent a user from accessing the actual pivot table itself. So they would not be able to double click on a field value to get the data. Also, I am not able to upload a file due to work restrictions at this time. I have the field value of 10 listed in another sheet, so the user can see that John in July had 10 for the North area. I would like them to be able to get the data that makes up the 10 without having to go to the pivot table. I currently have no filters on the pivot table itself. In addition, the cell address could change depending on the source data for the pivot table so the formula you posted above my not always work.

Thanks CK76. I'm not sure if you saw the last part of my reply but the cell address within the pivot table could alter depending on the data available.

Ok thanks, makes sense. I'll see if I can get a sample together and post later. Appreciate the help

Another thought, and I'm not sure if this would be VBA or not. But is it possible to get the cell address from a GETPIVOTDATA result? If so I can use that to extract the data without the user having to go to the actual pivot table.