i mean, in sheet1 i have this:
in sheet2:
in sheet3:
my question is:
how can i use index/match across multiple sheets (even when new sheet is created, possible?) at sheet1 A1 (i have thousand lines in B column in reality)?
thank you all

in sheet2:

in sheet3:

my question is:
how can i use index/match across multiple sheets (even when new sheet is created, possible?) at sheet1 A1 (i have thousand lines in B column in reality)?
thank you all
Last edited: