Compare Worksheets and Return Differences

[bkeller83]

Hello,

I have been searching, for about a month now, for a macro that can help me out. I've found a few that were close, but not exactly what I'm looking for. So, I am enlisting the help of the Excel experts.

I have two situations and the first is as follows:
One workbook contains two tabs with "ID's" and their total amount due. I need to get the sum total due (Premium Due) for each ID within the two worksheets and have the results populated on a third worksheet (using ID and total due).

Worksheet names: 1) Membership Details 2) Eligibility Adjustments 3)* Total Due

I will then copy the results worksheet (manually) into a new workbook containing an existing worksheet of ID's and their total paid.

For the second macro I need to compare the total due in one worksheet (name - total due) and the total paid in the second worksheet (name - group), then have the differences displayed on a third worksheet (name - discrepancies). One step further... I need for it to display the ID, total due, total paid and the difference of the two (again using ID as the reference).
Compare Worksheets: 1) Total Due 2) Group 3)* Discrepancies

I've been using VLOOKUP and other manual formulas, but I find these to be tedious and time consuming. I would be forever grateful if I could simply run a macro and have this automatically computed for me.

Attached are two sample workbooks.

I truly appreciate any help that you all can provide!