Creating lists

I'm hoping someone here can help me solve what seemed to be a simple problem - but isn't, at least for me!

I'm on the committee of a birdwatching group; I organise monthly coach trips to nature reserves and receive booking forms and money for coach tickets. As well as this, on the same booking form members can pay their annual membership, buy season tickets for monthly indoor meetings and make donations to group funds.

I've written a workbook which handles all of the above, almost to my complete satisfaction. The fly in the ointment is on my Daybook tab which records all payments received and breaks the payment down into the various categories; I've attached an anonymised version. What I would like to do is to extract the data from the Membership, Indoor Meetings and Donation columns each to a separate worksheet so that it displays as a continuous list, that is without the blank spaces. I've tried using an IF function (if cell in MEMBERSHIP column is blank, then blank; if amount shown, then corresponding name) and then removing blanks, but because the cells contains the IF function they don't register as blank so don't get removed. I looked to see if there was a function called LIST or something similar but no luck!

Sorry - I obviously didn't make it as clear as I thought! Each of the new tabs will have only one column listing names; so, as I post a new payment in the Daybook which incorporates a payment in the Membership column, the name from column B of the Daybook will appear on the Membership tab but forming a list without the blank spaces between membership payments on the Daybook.

Wow! I've never even heard of an array formula before. The more I find out about Excel, the more I realise how much I still have to learn.

Many thanks for your help; it's greatly appreciated.