Need help for this problem

[Bomba]

Hi,
I have a workbook that consists of 13 sheets. 12 of the sheets are identical and represent the months of the year (Name of sheets are January, February, March, etc). In these sheets, I have all the information of all 125 workers. Every sheet has column C for workers' ID and column AI for the total hours of vacation leave taken that month.
I want to use the 13th sheet (Named Summary) to see the total hours of vacation leave taken for the whole year for each worker by writing the worker's ID in cell A1 and automatically total hours of vacation leave appear in cell B1.
Is this possible?
Note: The ID consists of the number and a letter at the end. Ex: 12345C.

Thanks in advance

[p45cal]

Best attach a workbook…

[Bomba]

Hi,
Link to dropbox:
https://www.dropbox.com/scl/fi/p6t8icu6 ... 8f64jl7exb

Thanks

[HansV]

See the attached version. It uses SUMPRODUCT, SUMIF and INDIRECT with a list of sheet names (month names) on the summary sheet.

Vacation Leave Records.xlsx

[Bomba]

Hi Master,
Thanks a lot, great work.