is there a way to link to several worksheets in one workbook based on a list in another?
say for example, i have a list of names in workbook1. in workbook2 each name on the list in workbook1 has it's own worksheet. in workbook1, i need to pull the value in cell A1 for each name on the list from it's respective tab in workbook2. Any suggestions other than manually entering the formula for each name?
say for example, i have a list of names in workbook1. in workbook2 each name on the list in workbook1 has it's own worksheet. in workbook1, i need to pull the value in cell A1 for each name on the list from it's respective tab in workbook2. Any suggestions other than manually entering the formula for each name?