I have an excel files with multiples tables, in my case: Calcul, 2024-02, 2024-03, 2024-04 …

I want to get data from each table according to the month (2024 & 02). Actuall, I’m making =SOMME.SI('2024-02'!B:B;"something";'2024-02'!C:C), but I want to make the 2024-02 part dynamic.

If I put the value 2024-02 somewhere (A1 for example), I can’t use it like =SOMME.SI(A1!B:B;"something";A1!C:C), or like =SOMME.SI(CONCAT(A1;!B:B);"something";CONCAT(A1;!C:C))