In our company every product has its own sheet were we track different parameter. To get a better view of these parameters i would like to 'scrape' all these sheets (if they contain any information) and structure them into one long list.

I have already a sheet containing all the URL's, so i need some kind of loop that goes through this list and takes (if any) data and put them into on long continues list.

I have already used the QUERY together with IMPORTRANGE and i have succefully combined two sheets... but i had to manually put in the URL, so this does not seem as a viable option for 100+ sheets (with more added every week).

Hope somebody can help med in the right direction here.

Best regards