Need help in consolidation of scores

[sonalg29]

Hi All,

I need your help in consolidating the scorecard through macro. some of the criterias are to consolidate the
scores of users for region "UK" & location "b". The header & yellow highlighted column(formulas) wouldn't change in "
consolidate scorecard." sheet. It would sum the values of column F,G ,(J,K,L) & (N,O,P) from scorecard files.
Also for column R - TAT , if all are hit, then it would be hit but it would be miss even if one of them is miss. I have attached two
scorecards & one consolidate file in which summary would come but this would gonna work for atleast 4 scorecard files.

Please help me in preparing this macro. It would be a great help.
Thanks in advance.