For a personal project, I am trying to build an application for data collection. This is the idea for the application

1. The user enters data into the spreadsheet template using either an android mobile phone or chrome browser


2. Each week, the user creates a new spreadsheet from the spreadsheet template and uses it for entering the data for that week
3. The application (google spreadsheet currently) then gathers data from multiple spreadsheets created in google drive and enters it into another spreadsheet similar to a dashboard.

Since this is a personal project and I don’t have a lot of time to learn a lot different languages, I am trying to figure out whether it is possible to implement this using Microsoft office excel and its online version (excel online). I have implemented a simpler version of this in google spreadsheet, and I think this is possible to do using google spreadsheet.

However, the sheets have got complex enough that I think I have to start reading up on the google drive API etc.

At work, I am already learning about VBA and excel. So I am wondering if I can just stick to excel and VBA and accomplish this. I think this would have been definitely possible if I was just entering data using my laptop. However, I am wonder if excel online has the functionality to gather data from multiple “Excel online” spreadsheets in a similar fashion as that of google spreadsheets.

Thanks for your help

Jeff