Summarising data from multiple sheets

I have a to do list on excel which spans 5 separate sheets (all within one file). I have given each item a priorty number e.g. 1, 2 or 3. I wanted to summarise on the first sheet how many priority 1s, 2s, 3s I have. How would I do this?

Thanks in advance

Add 5 separate COUNTIFs together...

e.g.

Please Login or Register  to view this content.

counts how many 1's are in column A of each sheet and adds them together.

or, more flexible, if you list your sheetnames somewhere on the summary sheet and then name that range of sheetnames something like TabNames

then use formula:

Please Login or Register  to view this content.

or even... if your sheetnames are consecutively numbered... like Sheet1, Sheet2, Sheet3, etc...

Please Login or Register  to view this content.

where "Sheet" is the prefix of each sheet name and A1&":"&A5 signifies Sheet 1 to Sheet 5