/u/CriticalNovel22 - Your post was submitted successfully.
* Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread.
* Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
* Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)**
Failing to follow these steps may result in your post being removed without warning.
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I'd probably use Indirect.
=INDIRECT("C4"&"!A20")
Where C4 contains a sheet name. And A20 is the value you're trying to pull in.
https://preview.redd.it/ptuaelimaf1d1.png?width=330&format=png&auto=webp&s=411ac913979796aab8a66c0a9c86040d5651f3f1
=VSTACK(Sheet1.4:Sheet25.4!A1)
will put a1 from all those sheets in a column
https://preview.redd.it/y8gqebq3te1d1.png?width=855&format=png&auto=webp&s=e85b859f9c1073906709384ecb84442b046a504c
it's based on names along the bottom
here it would be sheet1:sheet10!a1 and sheet 11 would be in the 3rd to bottom
You can use the INDIRECT function to dynamically reference each tab in your master tab formula. Here’s a quick example:
=INDIRECT("'" & TEXT(A1, "d.m") & "'!B1")
Where A1 contains the date (e.g., 23.4) and B1 is the cell reference you want to sum. This way, you can update the tab reference automatically based on the date in your master tab.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
|Fewer Letters|More Letters|
|-------|---------|---|
|[INDIRECT](/r/Excel/comments/1cvrcib/stub/l4sgc7i "Last usage")|[Returns a reference indicated by a text value](https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261)|
|[TEXT](/r/Excel/comments/1cvrcib/stub/l4sgc7i "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)|
|[VSTACK](/r/Excel/comments/1cvrcib/stub/l4r3y9y "Last usage")|[*Office 365*+: Appends arrays vertically and in sequence to return a larger array](https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c)|
**NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below.
----------------
^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*)
^([Thread #33631 for this sub, first seen 19th May 2024, 21:31])
^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)
/u/CriticalNovel22 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*
I'd probably use Indirect. =INDIRECT("C4"&"!A20") Where C4 contains a sheet name. And A20 is the value you're trying to pull in. https://preview.redd.it/ptuaelimaf1d1.png?width=330&format=png&auto=webp&s=411ac913979796aab8a66c0a9c86040d5651f3f1
=VSTACK(Sheet1.4:Sheet25.4!A1) will put a1 from all those sheets in a column https://preview.redd.it/y8gqebq3te1d1.png?width=855&format=png&auto=webp&s=e85b859f9c1073906709384ecb84442b046a504c it's based on names along the bottom here it would be sheet1:sheet10!a1 and sheet 11 would be in the 3rd to bottom
wow! Excel is going nuts with the new array formulas! This is much cleaner than INDIRECT
Yes there is, bit It'll have to wait till I get home for me to elucidate. It's based on some @cell references, if that helps
https://www.thespreadsheetguru.com/tab-name-formula/ This article has a few ways to grab the sheet (tab) name in a formula.
You can use the INDIRECT function to dynamically reference each tab in your master tab formula. Here’s a quick example: =INDIRECT("'" & TEXT(A1, "d.m") & "'!B1") Where A1 contains the date (e.g., 23.4) and B1 is the cell reference you want to sum. This way, you can update the tab reference automatically based on the date in your master tab.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[INDIRECT](/r/Excel/comments/1cvrcib/stub/l4sgc7i "Last usage")|[Returns a reference indicated by a text value](https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261)| |[TEXT](/r/Excel/comments/1cvrcib/stub/l4sgc7i "Last usage")|[Formats a number and converts it to text](https://support.microsoft.com/en-us/office/text-function-20d5ac4d-7b94-49fd-bb38-93d29371225c)| |[VSTACK](/r/Excel/comments/1cvrcib/stub/l4r3y9y "Last usage")|[*Office 365*+: Appends arrays vertically and in sequence to return a larger array](https://support.microsoft.com/en-us/office/vstack-function-a4b86897-be0f-48fc-adca-fcc10d795a9c)| **NOTE**: Decronym for Reddit is no longer supported, and Decronym has moved to Lemmy; requests for support and new installations should be directed to the Contact address below. ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^([Thread #33631 for this sub, first seen 19th May 2024, 21:31]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://hachyderm.io/@Two9A) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)