Compare information existing workbook sheets and paste into a new sheet in workbook

Hi there
i seem to be having a problem with my "master copy template"
i have an online store selling computer products. i have a list of suppliers that i work with. what i had created for me by an excel master that i just cant seem to track down is this amazing template which contains all the products that each of my suppliers sell.
the macro works in such a way that it copies all the information to a master sheet in the existing working for all the suppliers.
the template also checks for same product codes and distinguishes which supplier has the cheapest price and copies that price to the master sheet.

the problem that i am having is the following
if a sheet has a product of similar reference, e.g TD-ARCHERD2 and TD-ARCHERD20, it copies the incorrect price into the master sheet. this can be quite annoying for customers.
ive attached a sheet with some examples for each supplier and ran the macro to copy into the master sheet. ive highlighted in orange & yellow the errors. The blue indicates same product code different price which is working correctly.

can one of you geniuses out there assist me in rectifying this error.
i would also like to add additional tabs not just 3. can this also be done?

<a href=http://www.filedropper.com/mastersuppliercopytemplate><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >upload files free</a></div>