Start from where the process stopped

Hi, I want to scrape a data from website where in 1st page it contains 25 rows and when you click on view application it opens a new tab with headers in the left. I have 10 rows with each column headers on left. I want to get this individual rows using get value and write to Excel data vertically itself with headers on A1, B1 and so on. Close the 2nd tab and continue to click 2nd row in the main page and once all 25 rows are completed click next page and move to next page. If it fails in inside the 2nd iteration of while activity of 25rows start the process from the same counter value and not from beginning row and also write the data parallel activity in Excel rows to quicken the process.