Collecting data from two worksheets and copying to a summary

[lngbrdguy]

I have two worksheets in a workbook. Worksheet one is named CLAIMs, worksheet two is named UNITS. I am trying to compare how many units for each model were sold per month and how many service claims for each model unit were issued for the same month...trying to get a percentage of claims to sales.
I have the data in two different pivot tables but would like to put the totals next to each other in a summary sheet by month.
On the claims sheet each entry equals one service call. On the UNITS sheet a dealer may have purchased one or more units per entry.
make sense?

 

[Fawlty1]

If I understand the question correctly, try using sumif formula. example:
Insert a new sheet into workbook and name it "Results", Label cell A1 "Model#", label cell B1 "Qty Purch". and label cell C1 "Claims".
List all Model#'s down column A.
In cell B2 enter: =SUMIF(UNITS!A:A,Results!A2,UNITS!B:B) & copy formula down.
This assumes that on sheet named UNITS, column A contains Model#'s & column B contains qty purchased.
Use the same formula for C2 except instead of UNITS Sheet use CLAIMS Sheet.