If your multiple source sheets are identically structured,
this sample from my archives might be of some relevance:
http://savefile.com/files/414328
Interactive Summary.xls
(nicely rendered, full details inside)

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Prescher" wrote:
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.