Hi All,

I have a workbook that has multiple sheets. Each sheet/tab has a different
project name but the cells A:13 - A:19 on each sheet all refer to team
members names. On a new worksheet w/in the workbook I want have a list of
team members names in Column A and want to add in the number of times their
name appears w/in cells A:13-A:19 across all worksheets. For Example:

Multi Sheets have the following names in the range of cells:
John
Mike
Chris

Chris shows up 5 times total throughout all the sheets so on the New Sheet
"Resources" I want it to look like this:

Column A Column B
John 0
Mike 0
Chris 5 - this is a sum of the number of times "Chris" was
listed in the cells across all the worksheets.

Help!! It may be simple, but I am stuck in the mud....
Thanks in advance!