Pivot Table or Function??

[jo74]

I have six worksheets in a workbook listing the odometer readings for
different types of trucks among other info and i want to be able to create a
table that will count the differents types of trucks on each worksheet.
Sort of like this:
sheet 1 sheet 2 sheet 3
type 1 10 11 9
type 2 5 4 11
type 3 13 10 9

Not real sure about pivot tables with multiple worksheets.
Any help?

 

[cs02000]

Piece of cake !
Make sure all the sheets used to hold data have the same headings. On a
seperate sheet create a pivot table using consolidated ranges (with
pulls all the data together).
The rest is basic PT stuff.