Extract data from sublink on multipages

Good morning everyone,

I am quite new around here bu I have a issue trying to use the automation tool with scraping. I want to extract data from a table that is displayed when we click on a sub-menu type of windows. I have multiple links to extract data so it is quite difficult to create something.

. Here is the sequence to follow (sorry I needed to hide the data). I want to complete that sequence for each links on the left side to collect the data in an Excel sheet.

Thank you for your help.

Column names in all the tables in different links are same?

They are following the same table and names but sometimes some pages have more info added.