(Beginner) VBA Excel Coding, code to display newly extracted data

I’m a beginner in excel vba CODING and given a completed project to debug.