Checking

Hi I have an excel file with lots of tabs, now the column B of all the tabs contains SA or TA. Is there a way to generate a sheet with the tab name and the value of column B.

For example:
Sheet Value
TA001 SA
TA002 Both (As SA & TA are both present)
CO007 Both
TA009 TA

I am attaching an extract of my data for your reference.Please guide me,
thanks,me