findsearch in workbooks using userform

Hi Guys
This ones got me scratching!!!
I have 10 workbooks in one folder on a share point which each contain information of machine parts held on individual sites. The format for these excel workbooks are identical in that column1 is part number, column 2 is description, column 3 is On hand qty. etc.
I'm trying to create in another workbook code whereas when I open it a userform is displayed where I can enter either part number or description (part of) and do a search on the 10 workbooks.
I would then like the results displayed in this "search" workbook, that is columns 1-3 displayed, irelevent of search criteria.

A big ask I know but I seem to get bits of it right but putting it all together is causing me major grief!!

Thanks!!!!

Try the attached File. Instructions are on the single sheet in the workbook.
The code should work if the List to be searched is in each workbook on worksheet(1). Otherwise its easy to adapt the code.

Hi Kuskush

I was making my original code too complicated!!!
This will do fine thanks. I've made a couple of changes to suit.

Thanks 4 your help!!