How to auto populate an Excel sheet based on a master data sheet?

This might be a long one, sorry folks!

I'm attempting to make a worksheet to assist my supervisor in tracking volunteer hours. The number of volunteers and the dates they work are not consistent. Last year we had over 200 different people volunteering, some every week, some at certain events, etc.

We've got a master time sheet of columns for name, date, time in, time out, and total shift hours (h:mm), so a row might look like:

Eliza, 5/16/2026, 11:00, 15:00, 4:00

My goal is to make a tab for each month with a break down of who worked that month and how many hours they worked based on the master spreadsheet.

Example For January:

Eliza, 284:53

Jerry, 52:25

etc.

Ideally, it would auto populate both names and hours based on the data entered in the master sheet, for instance if Jerry works in January and March, but not February, he would show up on the Jan. and March sheets automatically, but since there's so much inconsistency, I fear that might be too unrealistic. Right now, I've been using =SUMIF for the hours, but that requires a little too much maintenance for what I would prefer.

I've attempted to use VLOOKUP and INDEX MATCH formulas (based on suggestions from another reddit post), but I haven't been successful. It's completely possible that I've not formatted the formulas correctly though.

Is this even possible to do? Any formula recommendations or ideas?