Need assistance w/combining 3 project into 1! Sumifs and vlookups. Please help!

Hello,

Attached is a project that i have been given to do.

The attachments consists of 4 tabs.
-Style List
-Summary
-Detail
-pre transfer units (in other words, inventory by store, by project name)

I am trying to make my reporting much easier. Basically to begin with my pretransfer units tab consists of inventory of the 3 different store numbers for the 3 different projects.

So for example in the Summary Tab, i have set up a format that will allow me to have results on one tab for 3 projects which is named at B1, H1 and N1.

on C3, i would like to know the formula that will calculate how many units of inventory does store 3 have that belong to project name "Sneakers".
on h3, i would like to know the formula that will calculate how many units of inventory does store 3 have that belong to project name "Branded Tees".
on N3, i would like to know the formula that will calculate how many units of inventory does store 3 have that belong to project name "Nike".

My detail tab will now consist of the data that will allow me to understand what is considered an Authorized Transaction. The concat styles on Cells C8 and below are the concat styles that are also approved styles.

So i would like to know what formula can calculate the quantity of how many Authorized Units were transferred for each project. The style list tab has all my Concat Styles with its prospective Project Name.

I hope this makes sense. all i would like to know is the proper formulas when calculating total Authorized Units by store by project name, and same for Pretransfer units by store by project name.

Thank you sincerely for viewing and reading my post!

D