List Generation across multiple sheets

hey this is my first post here as im starting to try and utilise excel more, problem being i have a lot to learn.

im currently working on a price configurator which has more than one sheet with parts and prices on it.
what i want to do is have a sheet where i can populate a parts list from the parts that i have values for.

i want it to only pull the lines out of the previous sheets with values next to them.
ive got a couple of documents off of other people which do similar things but need to be pointed in the right direction of how to go about making my own.


cheers
jordan

so heres a clean example.
i want it to pull the entire row into the totals page, but only if it has a value.clean example.xlsx

i have approx 7 sheets to work this across eventually