You can absolutely do this with formulas given your sample. A simple VLOOKUP or an IF(COUNTIFS would likely do exactly what you need. If its just for sheets you can just reference each sheet in each column of your template sheet. Should be relatively simple.