Text Web Scraping 1000 entries

Web scrape about 1000 entries. This is the file you will work into: LINK: [login to view URL] GENERAL INFO: 1) Look line number 2. You can see it is song # 1 in column A. 2) The title is in column B. 3) The book is in column C. 4) The hyperlink is in column G. 5) From columns H to Q you see the verses. (this information will need to be transferred from the link available in column G.) 6) The Refrain is in column R (this information will need to be transferred from the link available in column G.) 7) The Final is in column S (this information will need to be transferred from the link available in column G.) WHAT TO DO: 1) Whenever you see a hyperlink in column G, you need to open up that link. 2) On the page opened, you will see numbers starting at 1 and ending at 2 up to 10 (some songs have a few verses, others have many) 3) Copy each paragraph under number to right column in spreadsheet. 4) Copy "Refrain" information into "Refrain" column in spreadsheet 5) Copy "Final" information into "Final" column in spreadsheet INFORMATION: I provided 3 examples in the speadsheet. They are highlighted in yellow. Open up each link and see how I did it. These are different situations so should be done the same way when face this situation.