I think I'm on the tail end of the project, what I need to add for the code
is to add the email address in cell A1 on each spreadsheet based on the tab
name or the name found in cell a1 (both are the same). I have the total
list of offices on sheet1 and the following sheets are broken out based on
information per office, but not all offices are included.

This information changes daily so not all offices will receive a
spreadsheet.

Here's what sheet1 contains:

colA colB
office name email address

--------------------
The following sheets are the different offices and the names are on the tabs
as well as listed in colA of each individual sheet.
-------------------
What I want the macro to do at this point is insert a row on each sheet and
insert the correct email address found on sheet1 that matches the office
address found on colA which matches the address found on the corresponding
sheet.
So if sheet2 was for office Chicago, the macro would insert a row on line
one, and copy and paste the address found on the correct line from sheet1
where the 'chicago' name was found to the new line on sheet 2, then go to
the next spreadsheet and continue until finished.

I hope I explained this clearly. Thanks for your help.