Collecting data from auto- generated excel file

An excel file is auto-generated by a biochemistry machine that perform blood tests.
The file has a sheet named "test results" which contains detailed information about the tests
patient ID, Assay,Result ...etc.
I want that all tests performed be counted and grouped into one a table in a different sheet
i.e; the total number of tests performed under the name "glucose" for example.

Thank you