Want to send individual tabs of a worksheet to different email addresses

I Have a spreadsheet with 20 tabs I need to send each tab to a different email address.

I have been copying and pasting and emailing manually every week this year.

The individual tab names are cities (Liverpool, Manchester, London eg) and the email for each city branch remains constant each week Liverpool@, manchester@

Can anyone think of a solution? Using Microsoft 2010
Should i be looking at VBA and a macro based on the values

Any help much appreciated

Bill

you can write the macro to send to email address " & thistab & "@service.domain where thistab = the name of the tab using thistab = activesheet.name

make the macro select sheets i where i = 1 to sheets.count