Excel 10: I should specify that I would like this task to be automated

I apologize if this is incredibly basic, if so just give me a function name or a direction to head and I'll take it from there.

Data I have: Statistics on hospital linen usage for a department. I have their actual usage per item and usage estimates from the nursing staff.

What I'm Trying to Do: I want to run a large series of checks for each item or sets of items. For instance, let's say they have 30 beds and the nurses estimate they use 2 pillowcases, 1 sheet, and 1 blanket day/patient. The usage and averages lineup except for pillowcases where it looks like they use 6 day/patient. Some units use pillowcases to line drawers or other stuff like that, so I want to run specific checks like this for each item.

I've been doing nested If-then statements (seems like i should learn indexmatch right? I don't know but these nested statements are tedious) to compare ratios and to output text based on the results. I have a sheet that looks for all of these but maybe only 2-5 out of 30 checks get tripped per unit.

What I'd Like to Do: Have a space on my report sheet that would copy whatever recommendations were tripped (e.g. Check improper pillowcase usage), eliminate any spaces, and output the text on consecutive lines.

So I go from this:

check pillow usage


using spreads to warm instead of blankets

Washcloth loss occurring

To this:

check pillow usage
using spreads to warm instead of blankets
washcloth loss occurring 

Thank you for your time and help.