I'm not quite sure what you're looking for, but something like
the following may get you started:

Dim WS As Worksheet
For Each WS In Worksheets
MsgBox WS.Name
Next WS


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Ben" wrote in message
...
Hello. I have about 16 tabs, all with very different names for
the same type
of data. I need a way to be able to automatically get the
names of all the
tabs so i can pull the need info out easily. Any ideas? is
there a generic
term that will work?

Thanks Ben