I have 1 source sheets with 12 tabs and many 200+ target sheets with 13 tabs 12 that ‘corrospond’ with the source sheets.
Currently the goal would be to have as little needing to be manually changed in each tab of the target sheets as possible.
1 workaround has been to add a column to the each of the source tabs with a refrence cell and call that.
=QUERY(IMPORTRANGE("URL", "!A1:T"), "SELECT Col5, Col6, Col7, Col8, Col9, Col10, Col11 WHERE Col1 = '"&A1&"' AND Col2 = "&Overview!B2*1,0)
This works but I would rather not have to add a clomun and fill it all with the same thing.
Instead I want to reference the sheetname from the source sheets. Something like:
=QUERY(IMPORTRANGE("URL", "!A1:T"), "SELECT Col5, Col6, Col7, Col8, Col9, Col10, Col11 WHERE Col1 = **'"Sheet1"'** AND Col2 = "&Overview!B2*1,0)
Toni4tonight is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.