Pull in data from another sheet based on an individual without crashing Excel.

Hello!

I am working on a project that pulls in data to generate a statement for individuals. I have everything working except on the supplemental sheets. I have a formula pointed at a concatenate (name+row number). It allows me to pull invoice data. Issue is there are some people with over 500 invoices. In my current setup it is vlookup to the concatenate and ifna then blank. I have it working pulling in the invoice data in order. Issue is when I try to carry that formula down to row 400+ the excel just freezes. So for instance on row 302 there's data, but if I pull the formula for each column down the row, Excel freezes and it never allows me to go further with the formula I am using.

TLDR: Trying to find a solution to generate/pull in data to generate a sheet that has invoice data that doesn't crash Excel. Should I switch over to index/match or will that not help performance.