I need help with VLOOKUP for an excel spreadsheet

I'm in the process of creating a spreadsheet that will be used to check stock levels for a bulk of products.

I need a VLOOKUP formula creating and adding that will pull data from the 'base product sheet' though to more formatted and organised supplier sheets. The supplier sheets will have product codes that will correlate with codes on the 'base product sheet' in order to pull them through.

I also could do with some conditional formatting adding to quickly highlight potential changes that I need to make to an e-commerce site based on the data. I can discus this in further detail.

I've attached the spreadsheet with a small sample size. The spreadsheet has notes on the cells/ column that feed into the columns on the supplier sheets and notes on the columns on the supplier sheets to explain their purposes.

Once the project is completed I will just scale it up myself and add the additional products and supplier sheets.