Using TRANSPOSE for 2 or more worksheets except for 1

[kualjo]

In the Name Manager, I have one called Sheets which has the function

=SUBSTITUTE(GET.WORKBOOK(1),"["&GET.WORKBOOK(16)&"]","")

to return a list of all worksheet tabs. I then use that as =TRANSPOSE(Sheets) to create a vertical list on the first sheet to pull information from all other worksheets. I'd like to be able to leave that first tab name out of the list so that it starts with page 2 (having the page 1 tab name on page 1 is redundant). Is there a way to modify the function to have it ignore the first worksheet? Any other possible solutions?

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[kualjo]

Thanks for calling that out Fluff. I haven't been here in quite a while, not fully up to speed on everything. It is Office 365.

 

[Fluff]

Thanks for that.
How about

=DROP(TOCOL(Sheets),1)