Creating a code to count and extract data from template to master file

Ok so I have been working on this code for a few weeks now. Basically I have to write a code where I choose a folder and within that folder multiple excel files are opened and certain data is copied from certain cells and placed into a master file. An issue comes when the template file is not 100% identical throughout all the files. Basically for a certain part of the code instead of copying the cell data I want to take the raw data, count it and then place it into the master file.

Attachment 438974
So this is the "template file" I need to sort the data in Range F and extract the totals into the master file.

master findings.PNG
This is where they need to go.

Please Login or Register  to view this content.

This is the code I have now(minus some copies of cells (80+ total))
In this code I am copying values from the coversheet vs protocol. for the data I need it is in protocol.

I know this is not the clearest of descriptions but any thing will help and I can clear up any confusion if need be.

P.S. I am not a very proficient coder. I have some C++ knowledge and a little bit of VBA

Thanks
Branden