So I have this formula below where the data comes from Classeur1.XLSX and the result is outputted into PlayerStats.XLSX. To make it clear I log daily stats of a Hockey Team, everytime they play I import a table from a websibe where the log of the game become availaible in Classeur1.XLSXl. The first Match function refer to a name, in this case it's "Alexander Radulov", the second match refer to a statistic, in this case it's the game time that this player played.

=INDEX([Classeur1.xlsx]Feuil2!$A$8:$O$25;MATCH("Alexander Radulov";[Classeur1.xlsx]Feuil2!$A$8:$A$25);MATCH([Classeur1.xlsx]Feuil2!$M$6;[Classeur1.xlsx]Feuil2!$A$6:$O$6))


For the day one I would import the table from the website in Feuil1! =INDEX([Classeur1.xlsx]Feuil1!$A$8:$O$25;MATCH("Alexander Radulov";[Classeur1.xlsx]Feuil1!$A$8:$A$25);MATCH([Classeur1.xlsx]Feuil1!$M$6;[Classeur1.xlsx]Feuil1!$A$6:$O$6))

For the day two the table would go to Feuil2! =INDEX([Classeur1.xlsx]Feuil2!$A$8:$O$25;MATCH("Alexander Radulov";[Classeur1.xlsx]Feuil2!$A$8:$A$25);MATCH([Classeur1.xlsx]Feuil2!$M$6;[Classeur1.xlsx]Feuil2!$A$6:$O$6))

Day 3 to Feuil3! =INDEX([Classeur1.xlsx]Feuil3!$A$8:$O$25;MATCH("Alexander Radulov";[Classeur1.xlsx]Feuil3!$A$8:$A$25);MATCH([Classeur1.xlsx]Feuil3!$M$6;[Classeur1.xlsx]Feuil3!$A$6:$O$6))
...
...

Day 82 to Feuil82! =INDEX([Classeur1.xlsx]Feuil82!$A$8:$O$25;MATCH("Alexander Radulov";[Classeur1.xlsx]Feuil82!$A$8:$A$25);MATCH([Classeur1.xlsx]Feuil82!$M$6;[Classeur1.xlsx]Feuil82!$A$6:$O$6))


What I need is as I scroll down this formula I need the sheet name to count and change, Sheet1!(Feuil1),Sheet2!(Feuil2)...,etc.