Our company was using Google Sheets for the last several months and we had a system working great, but are now looking for an alternative. Below you will find the working example Google Sheets we were using. Basically, every call we receive is logged in a spreadsheet in a tab unique to each representative. We have a CURRENT WEEK tab which is supposed to hold a static version of all the calls received by every rep, sorted by date. In Google this was done with a =query() formula, seen in A2 of the attached sheet, but Zoho does not seem to support such a thing.

The best options I can think of are an array formula or a VBA script. I'm just not sure about an array formula because it seems that the arrayformula might need entered into every cell which will be filled, which is not possible with our setup.

The tab in the Google Sheet where all the data is merged and sorted is called MASTER TEST and is found HERE