Hey All,

I run this weekly report that utilizes a pivot table off of some data in an excel sheet. When I summarize the data by "manager" under the report filter option in the pivot table, it spits out the data by manager into individual sheets (10 to 15 different sheets). The problem is that the names in the tabs have to include an "IN" or "OUT" depending on the data im working with, after the manager's name. It's tedious to go through and rename each tab to put an "IN" or "OUT" after the name. Is there a way that I could put all of the managers' names into one sheet, and then have the macro look for them in the tab name of the sheets within the workbook and add an "IN" or "OUT" after their name? Thanks for your help and time.

- Sheebu