I have 2 spreadsheets. In one spreadsheet Material.xls there are 12
worksheets. The second sheet is Purchase history.xls which contains only
worksheet 1. For each worksheet in the material workbook I need to match
Column B with Column e in the purchase history workbook sheet 1. Each sheet
in both workbooks have a different number of rows. Each time a match is
found then I would like to return the value from purchase history column e to
material workbook sheet n to column P.

Can someone please help? If I have to do this manually it will take a great
deal of time.

Thanks in advance for your help.