An excel vba macro that looks up ASX tick code, copies news announcements and pastes into spreadsheets

I require an Excel spreadsheet to update historical news announcements from the webiress platform. You may be required to obtain a trial account to access the platform, located here: [login to view URL] Assuming that the user has already logged in to the platform, I require a macro that will: - Takes the ASX tick code from a cell reference in Excel, such as A1 = "[login to view URL]"; - Pastes this ASX tick code into the "Reports" tab of the "Security Info" sub-menu (located under the "Security" drop-down menu); - Requests the results; and - Copies (right click on the results) then pastes the results back into the spreadsheet. I have attached a pdf to more clearly demonstrate these actions.