I have a two fold issue. First, I have a workbook that has multiple sheets, each with specific contact history. Each of the sheets is named with the respective contact name (i.e. Bob, Ann, Tom, etc..).

Let's say on sheet "Bob" in row A I have a list of dates 21-Mar-16, 20-Mar-16, etc... in row B I have data such as type A, type B, or type C and finally in row C I have values of either win or loss.

On Sheet 1, I have a master list with the following column headers: Contact Name, Month, Type and Type by month. I'd like for this main sheet to display the win percentage by month, type and type by month.to collect the values for each of the contacts from their respective sheets.

As an example: Sheet "Bob" has data from 1-Mar-16 thru 19-Mar-16 with a total of 14 rows of data. Type A has 8 wins, type B has 1 win and type C has 1 win.

How can I pull the following data into my main sheet were say row 2 would be Contact Name: Bob, March 2016: 80%, Type A: 71.42%, March 2016 Type A: 57.14%, March 2016 Type B: 7.14% and March 2016 Type C: 7.14%.

Also, each sheet goes back 2yrs so the range would be specific to the month and year.

Thank you in advance for any assistance that can be provided.