Thanks.

I don't necessarily have to use INDIRECT between workbooks.

Still, how can I make this work? The individual student workbooks need to know which instructor attendance worksheet to get the data from. I put a formula in A1 on each sheet of the attendance workbook to pass the name of the lesson from the worksheet tab to the worksheet.