Compare two spread sheets to make one

Hello again, I will explain first that I am doing so hopefully you can better understand how to get the out come.
I am running reports for a big trucking company. I deal with many numbers indicating truck/trailers. I only need the actual truck numbers. I have a list of only truck numbers what I use to find on this report I run daily. I then have to delete all the trailer numbers off the report.
I need somthing using office 07 to compare my truck number sheet with my report and delete any number that is not on that truck list.
All numbers on both report and truck list are in column B. These are in seperate workbooks.
This will save me a long of time manually verifying all these truck numbers and deleting all the trailer numbers.
Please let me know if you need anymore information.
Thank you for you any assistance ahead of time.

Could you post the workbooks that you are using and a example ouptut? That would help us better understand what you need done.