I want to use an item # in one sheet to pull data from another sheet that
matches that number into a new cell.

If I have an item #72 on sheet 1 with 6 columns of data - I want to add a
7th and take new info from another cell on another sheet of that same item #.
Is there a function to do that? SMy sheets have 1800 skus ... help!

EG:

sku April Stats May Stats
ABCD 9 find and pull from another sheet