VBA Beginer -Real Estate Industry

[Big Boss]

Hi,
I am beginner in VBA,
I am currently working in the assets management and investment department for a mega project to develop public assets (Museums, Parks, Venues…etc.), and several real estate assets classes (Residential, Retail, Offices, and Hospitality, healthcare, and education).
Currently, we are working on developing a consolidated financial model for all the assets within the park and one of the outcomes of this model is to provide us with the potential lands value per plot (parcel), based on a discounted project cashflow.
One of the key outcomes of this model is to provide us with a prefeasibility and a potential land value (sqm price) that can be used as a threshold before going into a partnership with investors (Jv, SPV, …) so that we can have an estimate of our share (land-in-kind) on any JV.
Since the model needs to be updated frequently, what are the best-VBA-practices that can facilitate and help us in the process of updating the key assumptions (E.g., CAPEX costs per sqm for construction, design, land scaping, infra structure, ...etc.).?
I know this is seems very general, however, I am expecting at this stage to receive ideas and thoughts from those working in the industry and who might had faced such a challenge (updating the model).
This will help me a lot in approaching this challenge and establishing necessary requirements and data bases to activate relevant MACROS moving forward.
What I define as success here is when we reach a point where whenever we open the model and run one macro, all model outcomes are based on most recent assumptions.

Thank you for your time.

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
https://eileenslounge.com/viewtopic.php?p=320960#p320960
https://eileenslounge.com/viewtopic.php?p=320957#p3209573
https://eileenslounge.com/viewtopic.php?p=318868#p318868
https://eileenslounge.com/viewtopic.php?p=318311#p318311
https://eileenslounge.com/viewtopic.php?p=318302#p318302
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317704#p317704
https://eileenslounge.com/viewtopic.php?p=317857#p317857
https://eileenslounge.com/viewtopic.php?p=317541#p317541
https://eileenslounge.com/viewtopic.php?p=317520#p317520
https://eileenslounge.com/viewtopic.php?p=317510#p317510
https://eileenslounge.com/viewtopic.php?p=317547#p317547
https://eileenslounge.com/viewtopic.php?p=317573#p317573
https://eileenslounge.com/viewtopic.php?p=317574#p317574
https://eileenslounge.com/viewtopic.php?p=317582#p317582
https://eileenslounge.com/viewtopic.php?p=317583#p317583
https://eileenslounge.com/viewtopic.php?p=317605#p317605
https://eileenslounge.com/viewtopic.php?p=316935#p316935
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317030#p317030
https://eileenslounge.com/viewtopic.php?p=317014#p317014
https://eileenslounge.com/viewtopic.php?p=316940#p316940
https://eileenslounge.com/viewtopic.php?p=316927#p316927
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA