Subtract Dollar amount from 1 person, if can find that person on next tab.

Hi,

I have a rent delinquency report for April Rent for 4000 residents.

I have those residents pulled up on Tab, April - AZ Portfolio Delinquency.

Most paid, but now on a new tab I want to be able to drop in the May rent amounts titled, "May-AZ Portfolio Delinquency"

I want to be able to separate the months, but the software won't do that, so after I drop in the delinquency total for May (which will include April), I need a formula to find the matching unit number from column 1 on April's tab and find the matching unit number on May's tab and subtract the amount in column F that they had in April from May's total amount. Hope that makes sense.

Thanks for the help!!! You guys are so freaking smart!!

submitted spreadsheet for further detail

Can you do me a favor and look at spreadsheet I submitted to for review?