Need help to create a search tool

[Kiran_26_Jadhav]

Hi All,
I need to create a search tool which will search the data entered in a particular cell with 2 different tabs and return all the values in that particular row into a new sheet. The results should include data from both the sheets.
Can anyone please help me with a macro for this.
Thanks in advance.

 

[vletm]

Are You 100% sure that Your criteria match even 99% of my or anyone's solution?
If I make solution, are You ready to modify Your sheets?
... or ...
Would be easier for You, if You just upload You sample file?