Using data from multiple sheets
I am looking for a way to automate the process of taking multiple Zoho sheets and collating the data into one combined sheet (such that no duplicates occur).
Currently I can only think of importing all the sheets into Excel and then running a macro to perform the task.
Is there a simpler way offered by Zoho?