I use Sheets in my business to create product catalogs for wholesale prices. I have different sheets for different companies but the data in many of them is the same. I'd like these sheets to sync from the main document. I've found a solution on here, however when I use the following function, the image imported in the main sheet using the IMAGE function doesn't get imported:
=QUERY(IMPORTRANGE("key","All!A2:M130"),"SELECT * WHERE Col1 contains 'Home&Beauty&Fashion'")
Is it possible at all?