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?