Extract data from sublink on multipages

[Dave_Tanguay]

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.

[Madhavi (K)]

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

[Dave_Tanguay]

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