How to retrieve row number using search function

Hello

I have two sheets named as "Sheet 1" and "Sheet 2". In Sheet"2" there are group of values placed in Column A1:A10 which is a subset of text string written in "Sheet1" however in "Sheet 1" in column A multiple text strings are put in each and every cell.

I want to search "Sheet 2" values in "Sheet 1" text string of each and every cell, If there is any match in that particular text string need to return the row number of Sheet 1

Could you please help which formula to use for getting this result