Formula, Macro, or Pivot to compile stats?

Not sure if I would use a formula, macro, or pivot table, or even another method of data collecting, but here's what I have:

I keep baseball game statistics in a workbook and would like to calculate the number of consecutive games a player has a hit, dating from the most recent game date. (For those who follow baseball, I'm looking for the batter's current hitting streak.)

I transfer each game's statistics ("box score") onto a cumulative list of games played by all teams (attached worksheet). I would like to add a column that depicts the player's current "hitting streak."

The relative columns are A ("Player), C ("Game Dt"), F ("H") and T ("PA"). Would want to read up the data until the specified player has 0 in column F and column T is greater than 0.

I already have a pivot table for the players' statistics, based on the data in this worksheet...just need to add the hitting streak data.

Clear as mud? Suggestions?

I could use Access, but I'm not as familiar with it and I love working with Excel.

Thanks in advance!

Forgot to add that I use Excel 2017 from the Office 365.

Thanks for the input. Unfortunately, re-sorting the player list after each transfer of data would be too time-consuming. I can see the same data from my pivot table, but am looking for a quick reference rather than have to pull each player up. The formulas did help me see other potential, so thanks for that. I agree that a macro, pivot table update, or other method is probably what I need. Hopefully, I'll have some other feedback to this.