I have a Google Sheet with a first Sheet called Technique. From A2 I have a list of different sheet name.
A2 = Envoi1; A3= Envoi2; …

I have a sheet called Labels with A containnaing different name from A2.
In F i paste a function to get the most recent date from others sheet.

In Envoi sheet I have A from A11 containing the name related to the ones in Labels.
In the B I have the date.

I want to do something liek that:

=LET(
  label; A2;
  sheet_names; FILTER(Technique!A2:A; Technique!A2:A <> "");
  all_dates; FLATTEN(
    ARRAYFORMULA(
      IFERROR(
        VLOOKUP(
          label;
          INDIRECT(sheet_names & "!$A$11:$B$100");
          2;
          FALSE
        );
        DATE(1900;1;1)
      )
    )
  );
  valid_dates; FILTER(all_dates; all_dates > DATE(1900;1;1));
  max_date; IF(COUNTA(valid_dates) > 0; MAX(valid_dates); DATE(1900;1;1));
  IF(max_date > DATE(1900;1;1); TEXT(max_date; "dd-mm-yyyy"); "")
)

But I always get the date from Envoi1 sheet. Even if the date of Envoi2 is more recent.
For example in Envoi1 I have the label Test having a date of 12-12-2020 and Envoi2 with Test and date of 13-12-2024;

I should get in Label F of Test 13-12-2024 but I got 12-12-2020.