I’m currently trying to process a huge amount of data located in a number of workbooks

The structure of data is same. This image shows the data located in the first workbook:

And this image shows the data located in the second workbook:

My goal is to create a VBA code that will help to count and then return the number of values for to each group (First, Second, Third, Fourth) from different worbooks. Expected result:

Is it possible? Any help is highly appreciated!