Excel 2007 : Scan barcode and display contents of row

Hi,

I receive a monthly spreadsheet with over 45000 items on it, what I would like to do is be able to scan in a product barcode and be shown the contents of the row(s) containing this barcode.

Also if possible as the spreadsheet changes monthly would it be possible to create a macro to select the file to do the search on.

I've attached a spreadsheet with sample data.

Regards,

Aamar