Check next row for new list

[evandrobp]

Hello all, thanks in advance.
I've tried tons of formulas and combinations but no success. It doesn't matter if I have to add the tab name for each section of the formula or if there's a way to get every tab's names without mention it in the formula.

No VBA please (unfortunately).

I'm trying to apply a formula to a MASTER tab and this should give me all the rows from the next tab and so on...

i.e.:

MASTER​

[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]Item Id[/TH]
[TH]Item Description[/TH]
[/TR]
[TR]
[TD]273623[/TD]
[TD]AABBCC[/TD]
[/TR]
[TR]
[TD]935155[/TD]
[TD]BBCCDD[/TD]
[/TR]
[TR]
[TD]644229[/TD]
[TD]DDEEFF[/TD]
[/TR]
[TR]
[TD]908624[/TD]
[TD]EEFFGG[/TD]
[/TR]
[TR]
[TD]204115[/TD]
[TD]GGHHII[/TD]
[/TR]
[TR]
[TD]18424[/TD]
[TD]IIJJKK[/TD]
[/TR]
[TR]
[TD]389924[/TD]
[TD]KKLLMM[/TD]
[/TR]
[TR]
[TD]927228[/TD]
[TD]MMNNOO[/TD]
[/TR]
[TR]
[TD]199706[/TD]
[TD]OOPPQQ[/TD]
[/TR]
[TR]
[TD]490029[/TD]
[TD]QQRRSS[/TD]
[/TR]
</tbody>[/TABLE]
The orange color is from TAB_1 and the green color is from TAB_2 --> (the # of rows will always vary, it's not the same)

The thing is: sometimes I do have tabs with 500 or 1000 rows, it really depends on the week's numbers.

Is there a way to import all the data from TAB_1, TAB_2, etc. , to the MASTER only with the option of paste the report on the specific tabs?
When the rows from TAB_1 is done, jump to TAB_2 (from first cell), then jump to TAB_3, etc.

And if I add a row the TAB_1 it will add automatically to the MASTER/TAB_1 section and then update the list with the TAB_2 right after that, etc.

The MASTER tab should just get data from other TABS, and those ones may vary like I said. I did formulas using as reference absolute cells, relative, etc, but nothing. Always gave me the wrong solution.

Does it make any sense?

I really appreciate all your help guys!


(Please excuse the typos.)<style type="text/css"> table.tableizer-table { font-size: 10px; border: 1px solid #CCC ; font-family: Arial, Helvetica, sans-serif; } .tableizer-table td { padding: 4px; margin: 3px; border: 1px solid #CCC ; } .tableizer-table th { background-color: #1A80E4 ; color: #FFF ; font-weight: bold; }</style>

 

[evandrobp]

This is the link of the spreadsheet.

The cells in blue and green in MASTER are the ones where I want to get the data.

You can check the tabs "AA_DATA" and "BB_DATA" to see where is the values that I want.

And again, those cells from tabs "xx_DATA" are different every week.

https://drive.google.com/file/d/1duAj5WBJtbpNxmpP-wQcSJH21UKB848l/view?usp=sharing

 

[evandrobp]

Bump