macro to email worksheets to email list

[callen12]

i have workbook which contains data on inventories based on location. Each location has a tab which is named for the location. I want to email each tab/worksheet to the respective manager without doing so one at a time manually. So far cannot grasp how to do so.

I have a list sheet within the workbook with all of the tab/sheet names in one column and then an email address column to send it to.

I have also figured out how to create individual workbooks for each tab with the same name again.

I have tried to adapt several different examples but cannot seem to figure it out.

thanks for any help