I have a workbook with multiple worksheets, common denominator is that each sheet has an email address in cell b5. So eg sheet1 will have [email protected], sheet2 will have a different address, however sheet3 will also have [email protected]. So what I want to do is cycle through the workbook, select all sheet with common email address and move to a new workbook.

I know how to take each sheet and email it from excel using vb but I don't want to send two separate emails etc