Get list of sheet names between sheet x & y

[schtengraby]

Dear All,

I have groups of (active) worksheets between other (passive) sheets that are acting as delimiters (these delimiter sheets are named things like: 'A-start', 'A-end', 'B-start', 'B-end' etc.) and I need to get a list of the names of the sheets between each 'start' and 'end' delimiter. The sheets between the delimiters will be moved in and out of the groupings, hence the need to get a dynamic list as they move about.

So for example, if sheets 'Tom', '****' & 'Harry' are between sheets 'A-start' & 'A-end'
And sheets 'Alice', 'Barbara' & 'Claire' are between sheets 'B-start' & 'B-end'
I need a list of 'Tom', '****' & 'Harry' in Column 1 and 'Alice', 'Barbara' & 'Claire' in column 2
Then if 'Tom' moves to between 'B-start' & 'B-end' it needs to dynamically move over to column 2

Hope that explains - thanks a lot for your help.
Really appreciate it!

Schten

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Get list of sheet names between sheet x & y
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.