I need a Macro in Excel to scan all Outlook emails in a specific folder of my mailbox, which extracts any data from the Subject field, email body and auto signature that is contained in brackets and send it to individual rows in Excel. However I would like to use markers R1, R2, R3, R4, R5, R6 so that the data in brackets marked R1 is spat out into Row 1 of my Excel s/sheet, data in brackets marked R2 is spat out into Row 2 etc.

Markers R1-R6 are part of the original email

I have tried mixing together different VBA code to do this but I am not a programmer and have not been able to achieve the end result. Also there is nothing on StackOverflow that answers this specific question. I would most grateful if someone could help