Good! Same as what I am doing. My file has multiple sheets too... just that I call them tabs.
Copy or import the whole price list into one tab, and each individual nav price in the main tab will be auto-updated too, because of the links in the appropriate cells.
============
Here's another trick... just to verify that the nav price is linked correctly, since the price list might changed and hence linking to another fund instead.
The main tab or sheet has data as below:
Date1, Fundxxx, AmountPaid, Units, NavPrice, CurrentValue, RoiAmount, ROI%, CAGROn the
same row, off-screen on the right side, I have also:
PriceDate, Fundname, NavPrice, Change, Change%- I don't link the above cell containing the NavPrice directly to the price list.
- I link it to that NavPrice cell at the far right.
- Hence if the link got messed up, the FundName will also show the wrong fund.
When I scroll to the right, I can see the daily changes too.

Interesting cross checking... the % change is nice for me to include as well