You also need to use Read from Excel worksheet on the second sheet, too, after setting it as active. Store the outputs in a separate variable.
And then within the loop that you have already built, use whatever UI actions you need for populating the fields in those web pages, and target the data from the second data table you read from the second sheet.
The question here is whether the second sheet contains different info for the different links and thus also needs to be looped through? I can only see a single row of data in the second sheet. If that's the case, it should be rather straight-forward.
-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.
I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.
