How to navigate through the browser and scrape data from it?

I have a small issue I can’t get along with.
I need to scrape data and extract it into table but not via ordinary data scraping tool.
I have a website list of shops:

I need to copy name of a hope into 1 column. Click on the shop (as it opens a new tab), gather phone, email, website from the tab (all in separate columns), then go back to general list and again open tab with detailed info - gather it and repeat this action to all shops.
May somebody explain how to do this? or refer me to video class or something
Thank you !!!