excel club summary

Here's the situation: We run a charity business networking club [login to view URL] we meet every week members bring business referrals to the meeting - these are opportunities for business passed along to fellow members members may also bring visitors or earn a credit for doing pro bono work Members pay a small admission fee each week, this can be waived if they offer apologies,or are sick otherwise they have to pay for meetigs not attended withour good cause. We have a signing in sheet that covers all the points above - for example name, unique number, date, paid/absent/apology and so on I would like to be able to create a summary sheet for each month and ulitmately the year, of all the data on the weekly signing in sheets and also produce simple reports along the lines of Member number xyz gave x business referrals , attedend 3 times and brought 12 visitors during the mionth of whatever this might be ok is a straight excel sheet with summary or an access dataabse - but could also be done as a mysql web based project, which would of course be ideal for sharing with other team members your suggestions acknowledged and appreciated - Please demontstrate previous experience - ask any questions by PM please Steve Elliott