Hello,
I reviewed the three spreadsheets you shared and have a good understanding of what you are looking for. Like you mentioned, this process can be automated such that all the data is transformed in your company's desired format on click of a button.
I can write such a macro with some inputs from your side regarding which data goes where. I reviewed the data-sets and some data points from your pivots did not map to any cell in the output. Like for example Cadastro. So, are these files (input and output) from different time periods? Or what are the rules for mapping. If you could share this information, I would certainly be able to help you. With my strong work history here, I can assure you that the solution I create will save you many hours of work by reducing it to a button click.
Do let me know if you would like me to work on this project for you and we may discuss the next steps.
Look forward to working with you and thank you for considering my bid.
Regards,
Rishi
Automyze Consulting - The Business Process Automation and Optimization Experts