Formula is only repeating, not continuing

I was wondering if anyone would be able to help me!
My formula when I drag it down repeats instead of continues, ie. goes back to one instead of sequentially continuing. This is it:
=COUNTIFS('P-01'!$D:$D, "Insertion", 'P-01'!$E:$E, "Surface",'P-01'!$F:$F, "Y")
=COUNTIFS('P-02'!$D:$D, "Insertion", 'P-02'!$E:$E, "Surface",'P-02'!$F:$F, "Y")
=COUNTIFS('P-03'!$D:$D, "Insertion", 'P-03'!$E:$E, "Surface",'P-03'!$F:$F, "Y")
=COUNTIFS('P-04'!$D:$D, "Insertion", 'P-04'!$E:$E, "Surface",'P-04'!$F:$F, "Y")
=COUNTIFS('P-05'!$D:$D, "Insertion", 'P-05'!$E:$E, "Surface",'P-05'!$F:$F, "Y")
etc.
I have gotten to 25, but it still repeats. I have tried pressing F9 / manual calculation but it doesn't seem to work.
Does anyone know how to make Excel recognise the pattern?
Thanks!

Thanks for your prompt reply!
Could you guide me as to how to use that?