Write VBA code to scrape member's info on the first page as well as the small window that opens when you click on each name in the first

The attached spreadsheet is the format of the final product. I want you to use VBA only to scrape information from the BCABD member's registry. The second attached file is the BCABD main membership page. When you click the name of any member, a small window will pop up with more specific info about the member, which is shown in the third attachment. The data to be collected into the spreadsheet include those on the main page and those on the pop-up window.