Looping through Worksheets in a Workbook with Similar Names

[stirlingmw1]

Afternoon All

I have a workbook with multiple worksheets (24) which I need to loop through checking for a certain text in row 1. If that text is found then that column is copied to another Sheet ("Results"). The text is set by items listed in the Named range "Locate" within Worksheet "Admin".

Each of the 24 worksheets have a 5 letter identifier followed by a Year span, i.e. BROC_22-23, BLYH_22-23. I have tried breaking down the Worksheet name to reference in separate parts but whatever I seem to do generates code errors.

Thanks

Steve

 

[Joe4]

You can use the SPLIT function in VBA to split strings based on characters like "-" or "_".
See: MS Excel: How to use the SPLIT Function (VBA)

If you need help, please give us more details, i.e. what exactly is the criteria you want to use to determine which sheets to include and which to skip.
You gave us a few examples of sheet names, but not the logic to determine which to include.