Copy data from multiple sheets in the same cell location and sort on several criteria

[cempey]

Hello,

I am trying to create a small spreadsheet to tally monthly scores for a club I am in. I have written an Access DB that worked wonderfully, but our new equipment is not licensed for Access so I am working out something in Excel. I have attached my working file but will summarize here as well.

I have created a template worksheet that we will copy for each new member we need to track scores for. This also references a Lookups worksheet which contains some of our constants. There are six competitions and the individual user worksheet (based on template) works as I hope.

I would then like to take some information from each user (Name, number of entries, number of honour awards and finally score) and list them all on a final worksheet (summary) and at the same time, sort that information on the following criteria, division, score, honour awards.

The number of members is fluid from year to year, but fairly static from month to month.

Any help would be greatly appreciated,

Thank you
Chris

[cempey]

Is this something that can be done? There have been a number of people viewing the post but no answers so I am starting to think not.

Any help is appreciated.