I’ve got a large google sheet with multiple tabs. Each tab contains a different “deal” and a list of salesfolks and what their commission percentage is for that deal, as well as their total cash commission. Each “deal” tab is structured identically, the only information that changes is
- Which salespeople are on the deal
- What their commission % is for the deal (1 person could have different percentages on different deals)
I want to create a separate sheet, or separate tab, whichever is easier, that shows every salesperson and what their total cash take-home was across all deals.
To do this, I somehow need to do a simple lookup across tabs. This is simple enough if you know all the tab names such as in this example, but in my scenario new tabs are being constantly added. So, while I can standardize the tab names, move them into their own sheet, etc. I will always have 1 tab/sheet per deal (though each tab will follow the same format).
Is there any way to merge data across all tabs in a google sheet without explicitly stating each tab name in the formula? I’m a decent programmer so perhaps App Scripts could help with this if it’s not possible with built-in formulas?
**TL;DR: **Merging data across all tabs dynamically in GSheets, is it possible?