Searching across multiple sheets VBA

[Leo55]

Hello,

Looking for some much needed assistance,
What I am trying to do I have a workbook with 10 sheets all with different types of data (different headers for each sheet).
What I would like to do is on a separate sheet be able to search for particular selectors and it to bring back the results for specific sheets (sheets 3,4 and 5 for example) bring back all the results for each sheet with preferably the headers.

Can anyone assist?

Thanks in advance