Write VBA to scrape members' info from this website

For the first project , go to https://aibc.memberpro.net/main/body.cfm?menu=directory&submenu=directoryMember, in the filter choose "by city", type "Vancouver", "Burnaby", "Richmond", "Coquitlam", "Surrey", "Delta", "Langley" respectively. For each of the seven cities, there is a members' list. The lists for different cities vary in length. Most of them have 1 page only, while 1 city has 96 pages. Please consult attachment 1 to see the features I need you to scrape, i.e. company name, website, address, email, phone, notes, owner's name. Except for owner's name, which is the name that appears on the main page, the other info you have to find by clicking on the name. Many of these names do not contain every feature listed in the spreadsheet, and that's OK. Just scrape the info that's available.