complete Excel novice and not sure if this is possible. In Excel 2010 I need to collate email addresses from an customer address book which is divided into different sheets for A-Z.

Each page of the address book is the same, obviously, so I need to collate a list of the email addresses from column E on each page to a useable list of email addresses. However, not every cell in column E has an email address and Outlook requires a "; " as a seperator for each email address. Can the empty cells be ignored and the seperator inserted for a range like this?

Can the resulting list be on a seperate sheet or will each sheet need it's own list?