Send inputs from several google sheets files to a final one

You may be interested in this thread, which was discussing the same issue a while ago

2 Likes