Hello,
I am Alex, working as data analyst in France. I'm an Excel/VBA expert, used to work on reporting, dashboards and Excel based tools.
If I understand it right, you need multiple files, to have a secured database and some user-friendly tools for each department. I have worked on similar projects and it gives me some ideas.
For the database itself, do you have MS Acces ? (The front user won't need it, but it can provide a more secure solution, if you want to be sure that each department can't access the "full" data. Excel cannot really provide this kind of restrictions).
I can also look on a solution to get data from the Wix Website, but i will have some questions to find the right way to do it.
If you still need this project to be done, I’m available. Feel free to contact me so we can talk about it !
Best regards,
Alex.