I am looking for a Formula that looks up the description on each tab and adds the amount in each column

[helenshas]

Hi I have 15 tabs in a spreadsheet that are departments and on each department they have a list of things that they buy; but they are not in order as some departments do not buy them, Rather than put the items on, then hide the lines which is the only thing I can think of doing, I need to make a summary on another tab for head office and give each department their one, but add each item via + 60 + 80 + 90 of the amounts on each tab. is there a lookup or grid formula I can use to total them on the summary,
for example
Tab 1 Tab 2 Tab 3
Department Office is on one tab Department Shoes Department Farnb Summary of items
Ice cream 60 Ice Cream 80 ice cream 90
photos 30 photo 20 photo 20
paper 20 Paper 10 paper 21
staples 10 Staples 6 staples 22
buttons 50 Buttons 5 oranges 26
rulers 25 Rulers 2 rulers 2
tables 10 Tables 1 pens 1
microwaves 6

Its quite a lot to add each tab one the rows as there are about 30 descriptions so any help would be much appreciated x

 

[Kerryx]

Use Pivottable wizard to consolidate multiple pages

workbook test.xlsx
	A
12	(blank)
Consolidated Info

If its not visible you can add it via File->Options->customize ribbon

 

[helenshas]

Use Pivottable wizard to consolidate multiple pages

workbook test.xlsx
	A
12	(blank)
Consolidated Info

If its not visible you can add it via File->Options->customize ribbon
View attachment 65023

Hi Thank you your answer
This will not work for me as I have multiple spreadsheets and they are in a format on each tab, for example we have actuals in each department and I want to bring the total into my formatted pretty spreadsheet