How to display output from one locked data piece and one client-input data piece?

Hi

I am trying to figure out a way to do the following. I suspect it will involve macros/VBA programming:

We have some data with a score that we provide (in a number form), and a score that a client provides. Together, the score of both will determine if this is a "priority", and if it is a "priority,: then 5 pieces of data will be displayed. So for each client, the displayed data will look different, and the things that are termed "priority" will look different. I have attached a sample spreadsheet of what OUR backend data looks like, with names of categories changed to protect company privacy. Can anyone help with this? I realize it may be a bit confusing so feel free to ask me clarifying questions! Thanks :-)

PS as to how the items are displayed in the end, as long as the data is correct we are flexible with format