With that many tabs, you probably want to ask that in the programming
section, as VB can loop for the number of worksheets you have. otherwise,
you'd have to use lookups, and 25 lookups is not a happy thing...

"pgarcia" wrote:

Hello all,
Workbook has multiple tabs (4-25+). All the tabs are setup in the same
format and layout. User will put an X in column N, O or P as a data
indicator. I need to have a tab that will give me information from column G
if N, O or P has an X in the column. I would like to have one tab show me all
the data from the tabs that are in the workbook and be able to add more tabs
if need.

Thanks