User Form to search and return data over multiple cells and worksheets

[nathandavies9]

Hi All,
I was wondering if any one could help with a some coding that i'm trying to find.

I have created a user form which contains a text box, which i will be copying multiple rows into from another workbook. i was wondering if anyone has ever created some code to the copy the information from the text box into a worksheet which is selected based on a combo box and after it has pasted the information in to the column require it will do a vlookup based on that column to then return all the information from all the worksheets in the work book?


Thanks in advance
ND