consolidating data out of several zoho sheets like Google Docs importrange

consolidating data out of several zoho sheets like Google Docs importrange

Hello,

One of our Zoho customers, we are Zoho alliance partner, wants to move its office docs to zoho-sheets but they ran into a problem.

Situation, see screenshot
Imagine we have 3 sheets with different filenames and different data.
How can we collect data from each sheet and merge it all together in 1 like shown on the screenshot.

At google docs
now they use Google Docs and their code is:
@Googledocs "=importrange(.....,.....)"
where dots refer to or are URL-based links to cells in different sheets

Question
How to do it in Zoho Sheet?
@Zohosheets "= ??? "


Please response to
Jean-Paul Damen
jpdamen@internetoveral.nl