I am currently using Google Sheets to make a list of videos and thumbnails. I have various sheets titled: Frying, Stewing, Baking, etc. Within each sheet, there are only two columns which include a thumbnail image and a text link. I would like to create a page which pulls the images from all these sheets into a column.
I have been using:
=Baking!A2
=Baking!A3
which outputs the thumbnail images that I wanted. The problem with this is, I have to copy/paste the formula each time I add something to a list. Is there a formula which does something similar to:
Check if the sheet1 A3 is empty; if true: skip to sheet2/3/4-100 A3 if not empty: output image.
Here is an example sheet https://docs.google.com/spreadsheets/d/1miRsEzIuSWVpwAbcVWWHIp74jVo2nJ8rOE8K61vJ_gQ/edit?usp=sharing