If you want to link multiple cells from another worksheet, you can use an array function, which lets you link a range of cells using one formula.

Excel has a feature that lets you open multiple hyperlinks at once. By using this feature, you can save your time in opening the URLs one by one.