How do I combine data in one spreadsheet from multiple spreadsheets?

I have attached the example to my original post. Thank you in advance for any help...and for your patience. This forum stuff is all new to me. I will be glad to answer any questions.

summarizing negotiators - solved.xlsx
Hello, thanks for your trust. About the forum - rules here is quite strict, on the other hand, thanks to that - it works so well. In general, if somebody helps you, it is nice to add him a reputation or leave some comments. Get reasonable name of your post and try to upload sample of data each time. (for example, I do everything in Czech localization, so I have no idea how to use half of mine function - with a different translation, there could be a different syntaxt as well. But - saving it - it is OK for everybody. And, it is much easier to explain it.

About your problem: have a look at it. Basic formula is for your 1352 main (this, you will need to change for each sheet).
Advanced formula is in 1300 main - this could be used everywhere if you add just sheet name into line 1. Countifs was used here.
Good luck.