copy & increment row +1 w index/match formula

I have searched all over and can not find a thread that addresses my issue. If I missed it - please help and direct me to it. My issue is that someone helped me on this forum with the following formula which works great. However, I need to copy it down at least 200 rows. Problem is when I've copied it down - row 1 stays as row 1. I need that to increment +1 because right now I am going in and manually changing the formula I copied down. There has got to be a better way.

[I even learned about macros and tried Range("P1:P200").Formula = "=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))" but had the same problem. It copied 1 all the way down.]

Currently when copied - formula looks like this:
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))

Desired Result when copied - to look like this:
=INDEX(Matrix!$B$8:$IV$65500,1,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,2,MATCH($B$1,Matrix!$1:$1,0))
=INDEX(Matrix!$B$8:$IV$65500,3,MATCH($B$1,Matrix!$1:$1,0))

Any help would be immensely appreciated.
Cindy

I'm amazed at how much information is contained in this forum and that people like you are so willing to help. I've spent hours on this and you answered it in a minute. THANK YOU! BTW - I tried it and it works great if you couldn't tell.

Cute baby!