Lookup wooksheet names and list in master worksheet

[MJgreen]

Hello,
I have 300+ worksheets that are all formatted the same. They are for different blends. I have a master sheet of all the ingredents that go into the blends listed in one column. I would like to use a formula to list all of the names of my tabs/worksheets (the "blend" names) in a row so I can use a vlookup to reference the workbooks.

I look forward to your responses. Thanks!

 

[T. Valko]

Hello,
I have 300+ worksheets that are all formatted the same. They are for different blends. I have a master sheet of all the ingredents that go into the blends listed in one column. I would like to use a formula to list all of the names of my tabs/worksheets (the "blend" names) in a row so I can use a vlookup to reference the workbooks.

I look forward to your responses. Thanks!

This link describes a formula method...

http://www.mrexcel.com/forum/showthread.php?p=2118912#post2118912

 

[MJgreen]

Thanks Valco! I haven't used VBA before but will give this a go.

 

[MJgreen]

Ha! not VBA. This formula rocks. Thanks again.

 

[T. Valko]

Ha! not VBA. This formula rocks. Thanks again.

You're welcome. Thanks for the feedback!