Apply Formula Based on Number Format

[JADownie]

I am trying to setup some calculations on my sheet using VBA.

I would like the macro to look for every cell in columns E:AZ that is a numeric value on sheet Target

Once identified, I would like the macro to apply this Formula R1C1 = "=Target!RC-Input!RC" in the exact same cell on sheet Output

So for example if on sheet Target E6=100, then I would like to apply this formula (=Target!E6-Input!E6) to Cell E6 on sheet Output

Is something like that even possible with VBA? Thanks in advance for any tips