Macro to Count Staff Attendance from a Monthly Schedule Calendar

[prkhan56]

Hello All,
I am using Excel 2010 and have the following problem.

I have duty schedule for various Staffs on various Stores. All Sheets are of same pattern.

I am enclosing a Sheet with my Problem only for one Store as a Sample. I have many sheets in the workbook (50+).

Each Staff name appears in a Row. Sometimes two Staff Names are in a Row (See Row 59 in the sample attached).
Staff Names will be varying for other Stores.

At present I am using Index Function with Countif to count the Names of Staff. (Please see in the sample). As there are more than 50+ Sheet I have to do it on each sheet manually which is time consuming and also when more than one name comes on a Row my Countif gives wrong answer.

I have color coded the Staff name Rows for sake of easy explanation of my problem.

I need a macro which will run on all the Sheets in this Workbook and give me the Staff Name, their count, Sheet name and the Month Value from Cell of F4.
See the desired output required in Range A70:D75.

Any help would be greatly appreciated.

TIA
Rashid