Looking up a string value for multiple adjacent cells

Hello,

I am trying to achieve the desired result in the attachment from the top default. I need to mine a value string like in F3 for a value that may be in A5:D5. Any value that is mined needs to fall into the same level as it's under in sheet 1 and if it is before level 4 all cells after it need to be left blank. Please note that the value from the string in sheet 2 is irrespective of the row in sheet 1. This is a model for sheets with about 50,000 rows so I would love an automated way to do this. Any advice? Thank you!