I have 13 sheets in this book all with different data in but want to be able to view the activity sheet (last sheet in book ) and see who has played what games without looking at all the sheets

example if Bazzeriom has played 4 out of 6 division 1&2 games(as on division 1&2 sheet) it is show on the activity sheet as per sample

But remember the data moves about on the sheets apart from the activity sheet as they are league tables

hope this helps explains it better

have enclosed a sheet

Any help with this problem please

Have now upgraded to excel 2010

Attached Files

All Sheets Master Plan with data in for example.xlsm (383.8 KB, 13 views)