Forum Discussion
List data from all tabs or worksheets into columns in a summary table
I have looked for the solution but always get answers that use a function (such as adding values together). What I want to do is create a list/column of the data from multiple tabs or worksheets int...
From your description, I believe the INDIRECT function is what you might need. I use it under similar circumstances to summarize data from across multiple sheets/tabs within a larger workbook.
I'm attaching two examples of the use of INDIRECT. One of those (INDIRECT_example) constructs the tab name using the word "Sheet" and a variable number. The other is more straightforward.
Here, too, is a website that explains it more thoroughly. https://exceljet.net/search?query=INDIRECT
mathetesThanks for the response, I will dig into this. If I can get it to work, you may have saved me a lot of repetitive actions. Much appreciated either way.
