Combining the multiple tables on separate sheets to a single table on another sheet

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

An alternative might be to simply put all information on a single page initially, since you already have the SUPPLIER as a separate column already. If you use DATA FILTERS on the SUPPLIER column, you can instantly see all products per a supplier, without resorting to double work.

Hope this helps!