I want to avoid this if possible. The above was an example, I have way more than 5 columns. Company order is somewhat random, so I don't want to have to find each column that relates to each company and manually insert that in the formula at the top of each column. I want this to be an automated process if possible, the above way I'd have to be manually adjusting the formulas as I fill out the master sheet every time I run pays depending on which company it is for.