Searching tables and displaying results

I have a table in sheet1 with columns A to K.

Column A is a unique ID number (lets call it ID_No), the rest is information linked to it.
Column C is a job number which is not unique.

What I want to do is as follows:

1. Search for and display unique ID. I want a user form (which will only contain one textbox - textbox1) for the user to enter the ID_No they want to search for. I then want Sheet2 (which has the same column headers as sheet1) to display all the data in that row.

2. Similar to the above but with Job-No which is not unique. This time, I want to search and display (as before) all the job numbers that exactly match the search data entered and to display the rows which contain that job number.

I need this to be done by VBA - not by using filters or any other method.

Help or link to solution appreciated.