Help please. How can I embed parts of several sheets into another

[Tom Weston]

For example:
I have several worksheets for a construction project, each relates to one
floor of a building, 1 sheet for each floor.
Each floor has electrical services and plumbing services.
Each sheet shows the items used and cost per item for each discipline on
that floor.

I would like a summary sheet for each discipline for the entire building
showing all the items and item cost for the project. I would have a summary
sheet for electrical and a summary sheet for plumping.

Items used will be added by each floor manager to the specific floor sheet
so the discipline summary sheet must take account of items being added on
the floor sheet and automatically update..

Is this possible, i can not find a way to do it with excel. I have tried
ranges but can not work out how to insert the range into a separate sheet.

Thanks in advance
Tom

 

[bob777]

I would create a sumproduct table on each individual sheet and then
merely add the values in identical cells of the sumproduct table into
first of all the electrical and plumbing summaries and finally into one
overall summary.

Bob