Excel VBA Code: Read-out, count and compare values with output in another sheet.

Hey Guys! I need your help.

I'm working on my Equipment list and I was hoping to make it a bit more efficient (for now with formulas).
I have my Data sheet where I want to input my data. And on a second sheet, it is counting, depending on the project documents,
the Quantities of my Tools which I have checked-out or used there yet. (In the end I wanna create some charts and diagrams to post later, but that's really not a big problem now.)

I was looking around to see if I find some VBA Macro Code and tried to Code myself (for some time already), but I got nowhere and a PivotTable is what I want to avoid.

Maybe one of the master programmers here can help me out please? :-) (Excel Sheet attached)
It would help me a lot.

11111.JPG
22222.JPG