Searching for Last Time Event Happened in Range

I have a large excel workbook, extensively linked for the hockey team I work with. Each player has their own sheet, with a game-by-game log of all their goals, assists, penalties, etc. This is all then bought together in a top sheet with all 21 players having all their stats summed up, showing me leaders in all categories, plus team totals.

I want to be able to have on my top sheet, the last time a certain player scored a goal, and who the opponent was.

My player sheets are set up as such in the attachment

So A4 is the game number (not really relevant in this situation)
B4 is the date of the game
C4 is the opponent

So on my top sheet, in say cell F3, I want it to look at the goals column (E4:63) on the sheet of the player in question (Smith), and find the last time a value was greater than '0'. Once it finds that value, I want it to take the value of column B on that row (where the value >0) and put it in F3, then the value in column C and put it in G3 on the top sheet

Make sense? Possible?

test.xlsx
Here's the sample file. Under this current setup, I would want F3 on Top Sheet to look at E4:E63 on 2 SMITH and return 'Nov-05'. Likewise with G3 on Top Sheet, with 'vs PGSK'. If the player were to score a goal (ie: >0 in E23), then F3/G3 would reflect that change.