I am trying to create a price list file.

I have a sheet for each supplier, with a table detailing the products supplied by that supplier. The column headers are:

Supplier | Product | Unit | Price per unit


I want to create a Full Product List sheet that will pull all of the products from each page, and display the prices for each product by supplier. This list should update live.

Is this possible with excel, without complex VB code