Consolidate data from multiple worksheets

Hi All,

I am trying to create an attendance sheet for computer classes at our Men's Shed.

I have been able to design the monthly pages with relevant data including VBA code, but am at a loss on the last page where I consolidate all those attendances.
As people can attend whichever session they want, there are going to be duplicate names as well as new names each month. Obviously, I don't want to duplicate those names on the last page, but rather one occurrence of each person but summing up all attendance over a period of several months.

I have attached a sample spreadsheet to better explain what I am trying to do.

I have recently updated to Office 365 so not familiar with all the new features from my previous version of office.

Thanks in advance.

Paul.

Thank you Ali, that works perfectly,

I have to admit that I don't understand about 90% of the formulas but it works beautifully. I will definitely be dissecting it bit by bit to get a greater understanding of how it works for future use.

Thanks again, you're a legend.
Cheers Paul

Sorry Ali, I thought I had responded re Reputation. I tried to add to your reputation but received the following message "You must spread some Reputation around before giving it to AliGW again"

For the record and anyone else who reads this post, your assistance and solution to my request for help has been invaluable. I am in awe of your excel skills and your willingness to share them with me and everyone else who is seeking help on this forum.

Thank you again

Paul