Help Please, I was thinking a "IF" Formula but I think that is the wrong 1

I have a spreadsheet with 17 worksheets. On 16 of them they have departments in columns D9:D16, they have 12 departments that get a dollar amount in columns F9:F18. I need a formula that bring all th...