I am having trouble generating a parts list from multiple sheets in a
workbook. I am calculating sell price for entire projects. I have many
different furnaces that can be used and I would like to generate a list of
the furnace and other equipment that I use into a final sheet that I can then
use to order materials for the project.