Finding item # match on multiple sheets

Im creating a vendor comparison for work. What I have is item numbers for products on multiple sheets. I would like to find a function that will search for a item number on multiple sheets and retireve the price in that row.
So if I have a item number in A2 I want it to search through another sheet to find that same item number and bring back the price, same row but found on column M. When it find the searched item number I want the price to come back to original sheet in a specific column, like the "price" column (M).

I have a product sheet with prices from multiple vendors. I need all of the vendors prices lined up side by side next to the prospective item # .

This is a very time sensitive project that was laid on me last second. Please help!

Use =VLOOKUP. Last parameter needs to be zero. Don't forget to freeze your table_array with $ signs. You can hit F4 when you edit your formula to do that.