Using User form to filter information based on information on sheet

Hi

I have created a user form that when I use the combo box by selecting the loan officers number her name and the branch which she is associated with is generated. I have another button on that form called "Generate Report" I want to be able by clicking on that button it will filter base on the loan officer number all loans written by that officer. I would also want to filter out only certain fields. I don't know where to start to write the code for the "Generate Report" button.
How do I start to pull what is needed for each officer.

Please assist I have uploaded the file. The loan officers data is generated from the "Loan Officers" sheet. The data to pull from the report on each officer is "Oct_2012". I am in urgent need of some assistance. Please