how to make quick filtering rows macro?

Hello,

I have a sheet with huge list of goods. I want to filter these lists by input value. First column has part code, second column has part name, third column has part description, etc.

I want it to work like this: if I write the code for the part in top cell, I want excel to leave only the rows with the code, containing the code I am entering. See the picture below. Could you please help me find the information how should I do this?

This is a full sheet:
http://s28.postimg.org/lusr2px7h/full.jpg


This what happens if I write the name "grease" in the top filtering cell: it filters and shows only the rows, which has the name "grease" in the part name:

http://s3.postimg.org/xz5kel8ib/grease.jpg

This file is provided for me from the supplier, but the VBA code is password protected. It is a nice system and I want it to make similar usage of my own for different purpose, and I want to know how can I achieve it.

Thank you for your help

I have changed the attachments to external files, I think they should be visible now.

InputBox might also be possible, but I want to to have a cell which looks as usual, but I want this:
I have a sheet, where each row is dedicated for one part (part has a code, description, name etc)
I have a first row with empty cells: A1 B1 C1 ...
Below are the rows to filter - where culumn A contains parts codes, B - descriptions, C - names etc
If I type 321 (which represents a part from the code) to A1, then all the rows below are filtered without any additional click to this way:
all the rows are hidden, except the rows which have parts with the:
codes containing the code segment entered to A1
It is difficult to explain in words, but working is really simple: each cell in column A have a code of the part in each row. I enter segment of code to A1, e.g. 123 - and then if a part in a row2 has a code which containts "123", then row 2 is left visible, if not - it is hidden.
This way all the list is populated, and if I type the full code to A1, then the only remaining row is row 2 with one part, because all the others are hidden, as long as there are no parts with the same codes.