Vlookup and Match function

I have three different spreadsheets that I need to match data with. I need to match item numbers with items numbers. after that I need to match the item numbers with a serial number that they correlate to. I need help, this is my first big project at a new job and have to NOT mess this up!!!!

is this a new workshop?

a sample spread sheet might help