Sum across specific worksheets based on a defined parameter

[Pbornho]

I have a workbook with 25+ worksheets, all identical formats that each represent a different client. Each client is assigned a project team. I want to be able to sum up the worksheets by project team, but have flexiblity in doing so when I add new clients etc. So a couple of thoughts.

1. Is there a formula that I can create that compares the worksheet name to a list of names assigned to a particular client?
2. Can I reference a cell in each worksheet that identifies that sheet as a client that is to be included in the team summary?

Example of worksheet sequence

Worksheet - Summary Sheet - All Clients
Worksheet - Client 1 Team Alpha
Worksheet - Client 2 Team Beta
Worksheet - Client 3 Team Alpha
Worksheet - Client 4 Team Beta
Worksheet - Client 5 Team Alpha
Worksheet - Client 6 Team Beta

I want to create summary worksheets (identical to the individual client sheets) for each team.

Patrick

[Pbornho]

I have been doing some research using INDIRECT

=SUM(INDIRECT(CLIENTNAME&'B16'))

where CLIENTNAME is the workheet name, and B16 is the cell reference in the spreadsheet. Trouble is I can get it to work for 1 spreadsheet, but having trouble getting it to work with multiple spreadsheets where there is a list of worksheet names listed in a named range CLIENTNAME.

???