Thanks for your reply. The reason for 90 separate sheets is that the workbook is a report consolidating monthly course evaluations. There is one sheet that gives an overview of each course by program. Then each course (the college I work at offers approx. 90 per month) requires its own sheet to provide more detailed data for that particular course. While 90 sounds like a lot, it is actually a consolidation of the data from over 2000 course-takers.

So to be more specific on the question, if I can avoid creating 90 formulas, that would be ideal. However, because these courses and instructors change each month, thus requiring every sheet to be updated every month, even writing 90+ formulas would be worth my time. I just don't know how to designate that the data from a cell in one sheet appear in the cell of another sheet.

Essentially, I am taking a list of the courses and the correlating instructor and creating a sheet for each one.

Does this clarification help? Thanks, again for the input.