Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Need to generate an index list from workbook pages

Copper Contributor

I have a workbook with 69 pages.  each page has student name field and a student ID#.


I need to create an index list of the students and their ID#s, how can I do that?

1 Reply

Hi @DonWFarr 


As per my understanding, you need to generate an index (Hyperlink) for all 69 sheets with a formula rather than doing it manually for each sheet.



You can achieve your requirement using the below formula:


Paste this formula in the first cell and drag it for all 69 sheets. Please also refer to a sample file for more clarity.


Please let me know if it works for you.