I have a properly made spreadsheet with the following functionality:
1. loading (VBA script) from structured Excell sheets (about 25 pieces) tables (attachments to subcontractors' invoices with a description of the scope and time of their work and costs incurred in a given month) and saving this data to a normalized table in the master sheet.
2. Based on the table in the master sheet, summary statements of work reported by contractors on a per-project basis (about 20 projects) are generated.
3. Based on the imported data, additional reports are generated on, for example, the budget of a given project and the profitability of the company implementing these projects.
I need to update this tool, which requires a contractor to understand how it works. After that, I will need ongoing support.