Hi All,

I posted this question in the worksheets group but received a suggestion to
come here.

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.

Note: Someone suggested signing a name to a cell but I have 45 resource
names.I
don't want to have 45 blank cells on each sheet for each of the resource to
match to.

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