Finding text in another cell with more text.

Hello guys,

i have an excel which will be used by testers.

They will add pages ($login,$home,$spectacles) to the excel, then they will input the controls used (users,names,emails,passwords)

In the next excel you will see from C11 to C36 , the pages that the tester will input, from D11 to D36 the web elements or controls that they will use... eg: users,passwords if they used only that data.

This is in the sheet 1, in the sheet 2 i want to:
1) scan the used pages
2) generate them in the sheet as A2 and A6 (sheet 2)
3) next to them show the controls used (listed , dropdown).


I attached the excel, it has some things in spanish but they are irrelevant, also Sheet and Hoja are the same .


Thanks guys!!