I have a main site from which new subsites are created whenever a new project is started. In each of these sites there's an Excel standard document where people fill in data about that specific project.
My goal is to create a database list in the main site that is automatically update with the content from those Excel files located in each project subsite.
I've seen many ways to transfer data from Excel to a list, but none of them worked so far.
Is this possible to be done?