Counting name data across different excel sheets and returing a total

[shaggy72]

Hi Guys & Gals ,

Struggling a bit to formulate a string to pick up the following information ;

Summary ( Final destination)
NAMECONTRACTIDDRYSDALE ASSIGNGVAP ASSIGNHAGGERSTONSETON
Abida, Mustapha0

Sheet 2
NAMEcontract
Abida, Mustapha1
Sheet 3
NAMEID
Abida, Mustapha
1

Problem I have is the the system is only giving me a text data. If this was a payroll number '914' it would be easy. But this not.

Help please

 

[Deepak]

@ shaggy72

What you said is not understandable.
Can we have a sample workbook with manual calculation.