90 sheets? Surely there is an easier to accomplish your ultimate goal. Perhaps if we knew the reason for the 90 sheets it would help.



Also, it is unclear from your question if you are asking how to create formulas or if you are asking how to avoid creating 90 formulas.

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.