Column A is a list of job titles. I have separate worksheets within the same workbook that are each named with each job title. In column B I am looking for a way to sum a particular array of cells in each worksheet. I was hoping to to be able to write a formula and drag it down my page, where within the formula it would identify which worksheet I want to reference (based on the value in column A). I tried the "Indirect" function, but kept on getting a "#REF!" error, and as I've never used that formula before, I'm clearly doing something wrong. Any guidance is super appreciated.