I have a worksheet where the first tab; Sheet1, contains product numbers in column A and nouns (product names) in Column B.
the second tab (crazy long name) has product numbers in column A, needs the noun from Sheet1 in column B, and loads more columns.

How can I get the program to search Sheet1 for the value in all the A cells on the second tab and populate Column B with the corresponding value from Sheet1 ColumnB?