in excel you should type entries carefully.
you must type 145175 (without a comma). you can format it with a comma. when you format this entry with comma in thousands place it LOOKS like 145,175 but the entry remains 145175. so when you use "find" function and put is as 154175 it will find.
similarly depends upon regional setup of excel the dates should be entered as mm/dd/yy.
regarding the second question of explaining the macro it is difficult. One way of understanding is
keep both the spreadsheet and the macro on both sides on the screen(by reducing them). now keep the cursor within the macro and
hit F8 successively. with the first hit "sub test" will be highlighted in color yellow .for each hit of F8 the yellow stripwill move to the next statement. with each hit see what change takes place on the spread sheet and that is how you can understand the macro. generally this macaro finds out wherever the input value is, and if found it copied to the master sheet. it loops through all the cells in each sheet and loops through all the sheets.
According to the macro if the entry is 145175 input box should contain 145175. but if you want to put 145 in inputbox and the macro to find 145175 some modification has to be done . In the macro there is a line
Set cfind = .Cells.Find(what:=x, lookat:=xlWhole, LookIn:=xlValues
in this see "lookat:=xlwhole" so that it will find the whole entry
if you want to find part of the entry (145)
REPLACE "XLWHOLE" BY "XLPART".
It all depends upon how far is your familiarity\with WRITING a macro;. If you are a beginner don't attempt now. learn macro and then you can become an expert. Best way to learn writing macros is suppose you have a small pronblem RECORD the macro taking all the steps and see the macro. you can understand the various statements and can modify it to be more general . If you are beginner both for excel and edcelvba get good books on excel(your version) and also on excel programming(your version). These books will be a useful guide provided you use excel extensively..