Excel Formula Help

Hi,  I'm hoping someone can help me. I'm desperaetly trying to work out a formula sort a script but just can't get it working.   I’m needing (if this makes sense) to be able to automatically input...