Summing instances of text across worksheets

[George]

Hello, I have a workbook with separate sheets for each month. The sheets
contain a list client names (entered exactly the same on each sheet). I need
to summarize how many times a client name appears in total. For example, John
Brown may appear Jan & Feb (=2) where Mary Brown may appear Jul, Sep, Dec
(=3).

I've been trying pivot tables without luck. Hoping someone can help.

Thanks in advance!

 

[George]

Never mind, I consolidated all the worksheet data into one and the pivot
table works fine.

Thanks anwyay!