Fill in the web address of the new web data query in sheet 1.

Fill in the purchase fund in sheet2, for example

Fund code fund name subscription amount subscription price subscription rate net redemption rate profit of the day

F2 cell input formula =vlookup(a2, sheet 1! $20: $200.4)

Others can be found by inputting formulas.

sheet 1！ $d$20:$e200 is the data area in sheet 1, and the websites are different.

4 is the column with net value in this area.

Just select the area in sheet 1 at a time and right-click to update.