returning entire row based on single or multiple criteria

On sheet 1 I have nine columns with identifying criteria that pertain to one object. On sheet 2 I want to label the columns as the same as sheet 1 so a user can type in the criteria to search for underneath the labeled columns. Some instances it may only return one row but could quite possibly return multiple rows. I don't know what function or how to set it up to make it work. Any help would be appreciated. I have attached a sameple workbook set up similiar to what I need it to be.

I tried what you posted about the advanced filter but cannot get it to work the way I would want it to. I'm trying to get it to work, so when you type in something different in the criteria cells. It returns the row or rows that match what your searching for on sheet1 in the results row below. So say I type in 15 for the dwg# in the search criteria. It would return the information for the dwg 15 in the results below, but if I would change the 15 to like 109 then it would either automatically do a search again and then return all information dealing with dwg 109. Maybe I need to put a button with a macro so when you enter the information you want. Then you would hit the button to return the information matching your criteria entered. The only problem is I have no experience with that. I attached an example which is how the information is setup and how I would want to enter the information above on sheet2 and it would return in under the column indetifiers beneath the search criteria on sheet2. I don't know if this is possible. Any help would be appreciated and thanks again for the information already. I don't think that is what I'm wanting but could be I'm not doing something right.