Gather data from multiple tabs of the same work book.

I have about 30 tabs of data. How could I get a count of a certain code used in a certain column. I use general codes "WP","R", in column C some tabs have one row of data some have 10. Just want a consolidation page to total up the amount of each code I use. Thanks for you help.

Simple but messy

Use Countif? if you have these codes in column C say just use the following but expand to include relevant tabs:

=sum(countif(Sheet2!C:C,"WP"),countif(Sheet3!C:C,"WP"),countif(Sheet4!C:C,"WP"))

Regards
Mark