How to fix a large range of cells??

Hi everyone,

I'm working on a database that requires me to copy and move some formulas around, but those formulas require me to fix some of the references they have, is there a way to avoid doing it manually?

I’m attaching a sample file that explains more clearly....

Cheers,
Kinauz