VBA/Macro Search from sheets in one workbook and display

Hi
First of all, apologize for the bad english. I am new to VBA/Macro. I got this excel spreadsheet (attached file) from wickets1210 threads.http://www.excelforum.com/excel-gene...readsheet.html. This spreadsheet is similar to the one that i tried to do for several weeks for my data project. (Credit to wickets1210..thanks). But the problem is in this spreadsheet, it is based on formula in the cells. So my question/request are,
1) can it be change to VBA code?
2) in the spreadsheet,it have option(drop down list) to search from which sheet or all and search criteria by poscode (first 2 letter criteria). Can the search be more refine as in the Postcode fragment's cell can have drop down list option to search from criteria in yellow cells?
3) the green cells after Postcode fragment where the keyword has to be enter. The original search criteria is the first 2 letters from postcode. How to search using function "keywords contain"?
4) what i plan to do also to add SEARCH BUTTON as the original spreadsheet is automatically search when finish enter the first 2 letter postcode.

Many thanks