Search columns in specific sheets and paste values on sheet1

Good morning folks,
I need your help altering a macro. I've been trying to make some changes for the past couple of days, but I haven't had any luck.
Currently, a user inputs a search value in cell C4 & presses on the 'search' button. The macro looks throughout all the sheets, except sheet1 and sheet2, and when it finds the value(s), it pastes the corresponding rows on sheet1. Please see attachment.
What I want it to do is instead of pasting values from all columns, I want it to paste values from specific columns- Column A, H, M, N, O, Q for e.g. And I also want it to paste only the values. Is that possible?

This is my code:

Please Login or Register  to view this content.

Thank you.

Try the attached.

Another shorter version.

Both of them work flawlessly. Thanks for your help AB33.