Excel VBA Coding Problem with If-Else Loop [on hold]

I have a Problem with coding a VBA for Excel.

I have two Worksheets. The first contains Names in Column B and Strings in Column E. There are multiple rows with one name, as there are multiple strings related to it. The second worksheet contains a list with Strings in Column C and a label (number e.g 2,3 or 4 etc.)

On a third Worksheet I want my solution ofnthe following problem.

The strings in the first worksheet shall be referenced with the strings in the second. If the string can be referenced, the corresponding name and label shall be displayed for all on a seperate worksheet..

Can anyone help me out?

Thanks