Scroll down a Complex Formula

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.

Your formula implies that the file Classeur1.xlsx is open at the same time as the file containing the formula. If that is the case, then you can use INDIRECT to do this - try the following:

=INDEX(INDIRECT("'[Classeur1.xlsx]Feuil"&ROWS($1:1)&"'!$A$8:$O$25");MATCH("Alexander Radulov";INDIRECT("'[Classeur1.xlsx]Feuil"&ROWS($1:1)&"'!$A$8:$A$25"));MATCH(INDIRECT("'[Classeur1.xlsx]Feuil"&ROWS($1:1)&"'!$M$6");INDIRECT("'[Classeur1.xlsx]Feuil"&ROWS($1:1)&"'!$A$6:$O$6")))

Hope this helps.

Pete

Exactly what I need thank you very much

Glad to hear it (though you don't need to shout it quite so loud !!)

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete