Hi Rohit,
The quickest way to recover from missing MSI files is to let Windows remove the broken installer references for you and then rebuild each program’s installer cache with a fresh copy.
Download the official "Microsoft Program Install and Uninstall Troubleshooter" (file name MicrosoftProgram\_Install\_and\_Uninstall.meta.diagcab) from Microsoft’s support site, save it locally, double‑click it and choose "Uninstalling".
When the list of applications appears, pick the product that refuses to upgrade, let the wizard complete, then restart Windows. That process erases the corrupted Windows Installer records that are pointing to the MSI you deleted.
After the restart, run the current setup package for that same application and choose Install. Because the stale entry is gone, the new installer can lay down a clean copy of its MSI into %windir%\Installer and register properly. Repeat the sequence for every program that was affected. Once each one has been through the troubleshoot‑then‑reinstall cycle, normal uninstall and upgrade operations will work again.