Grouping sheet in a workbook

B

Ben T

I have a workbook with 20 tab(sheets) in it. In each of
these tab at cell C5 is a name. Is there a way that I
can group these tabs by cell C5 so that they are right
next to each other without me manually doing so? Thanks

Ben
 
E

Edmund Seet

One way:

If u prefer by COLUMN, put this formula in the target
worksheet cell B1:U1
=INDIRECT("Sheet"&COLUMN()-1&"!C5")

If u prefer by row, put this formula in a your target
worsheet cell B1:B20
=INDIRECT("Sheet"&ROW()&"!C5")

HTH
Edmund Seet
 
Top