VBA to open link in chrome and open the redirected page and copy the link in new column

Hi All,

I am having a sheet with links.
I just want that, a macro should open the link provided in chrome and when the page loads, it should copy the link page after loading and paste in the next column .

eg.
https://support.hp.com/in-en/search?...38Z00X&filter=

if you open the above link it will redirect to the below link

https://support.hp.com/in-en/product...57?sku=2MB48PA

I have link in column "A" and require the final link in column "B".

Thanks, any help would be appreciated.