I've automated excel sheets before. Vlookups, VBA, conditional operations, using many logic statements and parentheses together to get the exact effect you're looking for and updating everything with a single/minimal input.
And because I'm new to freelancer, haré todo lo posible para no defraudar su confianza.