Extracting data from multiple email in email folder

Hi all, I am currently working on extracting data(a table and some individual texts) from multiple emails(same format) in an email folder and displaying the output on excel. However, am currently stuck as the excel is only displaying data from the first email in the folder. Really need help with this, hope to hear from somebody soon. Thanks in advance!

Try append range instead write range.