Creating a seemingly complicated summary sheet from multiple sheets

[avis_1989]

Dear experts,

I am working on a costing sheet which has multiple tabs for multiple cost elements. I need to summarize the data into one single tab, which will show the cost per service level. I have attached an example of a blank costing sheet, with blank summary tab.

Currently, I am manually linking the summary tab to the department fields, one by one as you will see in the example. My question- is there a better way to create the summary sheet using pivots ? The presentation of data should remain the same though.

Thanks for your help!
Avi

[noboffinme]

Hi avi,

Is it possible for each tab to have the same headings and then you could have them all on one worksheet one under another.

It wouldn't matter if some Field names aren't relevant to that cost element as you would just leave them blank.

You could then create a Pivot Table & use a SUMIF Formula to display your data in the Summary sheet.